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

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.


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question