Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2008

Tip: Looking for answers? Try searching our database.

Run Time Error 3343 - Unrecognized database format:

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Maury Markowitz - 22 May 2008 19:10 GMT
I am writing a query to populate an excel sheet in the same way that I
have in many occasions in the past:

1) open the db using DAO
2) run the query with OpenRecordset
3) transpose the array and paste it into the sheet

When I attempt this today, I get:

Run Time Error 3343 - Unrecognized database format:

Looking around on the 'net, this appears to suggest db corruption.
However, the db repairs/compresses almost instantly and reports no
errors. It can be used problem-free.

I have a reference to MS DAO 2.5/2.51 in Excel's References. Perhaps
this is too old, but I can't seem to find a newer one in the Available
References list.

Anyone have any ideas here?

Maury
Maury Markowitz - 22 May 2008 19:27 GMT
Ahhh, it's a version problem. Hand-including DAO 3.6 fixed the
problem.

Now does anyone know how to tell the OpenDatabase that I'm using
integrated security? It keeps popping up a dialog that has "Use
Trusted Connection" turned on, which I want, but I don't want the
silly dialog to appear. Is there some way to do this in the connection
string?

Nayrt
Jean-Yves - 23 May 2008 10:24 GMT
Hello Maury,

I suggest you use ADO instead for database connection.

Signature

Regards

Jean-Yves Tfelt
Europe

> Ahhh, it's a version problem. Hand-including DAO 3.6 fixed the
> problem.
[quoted text clipped - 6 lines]
>
> Nayrt
Maury Markowitz - 23 May 2008 14:44 GMT
On May 23, 5:24 am, Jean-Yves <JeanY...@discussions.microsoft.com>
wrote:
> I suggest you use ADO instead for database connection.

How do I connect to a mdb this way? Believe it or not I've never had
to do this in the past, I normally talk directly to the SQL Server.

Maury
Jean-Yves - 29 May 2008 09:13 GMT
Hi Maury,

Google for  ADO Jean-Yves.

I gave already plenty of examples
Or ADO connection/ ADO recorset.
Depending on the database format, only the connnection string is different.

Signature

Regards

Jean-Yves Tfelt
Europe

> On May 23, 5:24 am, Jean-Yves <JeanY...@discussions.microsoft.com>
> wrote:
[quoted text clipped - 4 lines]
>
> Maury
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.