Run Time Error 3343 - Unrecognized database format:

[Maury Markowitz]

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]

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]

Hello Maury,

I suggest you use ADO instead for database connection.

 

[Maury Markowitz]

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]

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.