Unrecognized database format

[Maury Markowitz]

Not having much luck today, it seems...

In my quest to find an efficient way to import data from various sources to
our sql server, I'm currently trying to experiment with an mdb full of the
links and then opening them in code in my main adp program. However, I keep
getting...

Run-time error '3343'" Unrecognized database format...

And this happens no matter what mdb I try to open...

Dim db As DAO.Database
'Set db = OpenDatabase("L:\Reconciliation.mdb", False, True)
'Set db = OpenDatabase("L:\Sandbox")

etc. All of these db's open fine in access. Soooo, can I use DAO in code in
an adp? I seem to recall having done this before.

Maury

 

[Tom Wickerath]

Hi Maury,

etc. All of these db's open fine in access.

Are these databases in the JET 4 file format (ie. Access 2000, 2002, 2003)?
If so, have you set a reference to the "Microsoft DAO 3.6 Object Library"?
If you happened to pick the Microsoft DAO 3.51 Object Library, then you can
only open databases in the JET 3.5 (Access 97) file format.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________