Unrecognized Database Format

[Jac]

Hi,

I am trying to connect a form to a MS Access 2007 database, named
Database1.mdb & saved in My Document folder. So, in the MS VB 6 form, I
drag-in a data control called Data. The property set as below:-

Connect: Access
DatabaseName: C:\Documents and Settings\Jacqueline\My Documents\Database1.mdb

After that, when I want to set the RecordSource, an error message pop-up
with the message stated: Unrecognized Database Format C:\Documents and
Settings\Jacqueline\My Documents\Database1.mdb

Thus, I would like to know what actually the problem is cause without settle
this, I can proceed with my work....
Therefore, if anyone out there who has been encountered with this problem;
could kindly please advise???

Thanking in advance.

Regards,

 

[RitchieJHicks]

Is it possible that your database is corrupt? Have you tried the compact and
repair feature?

 

[Jac]

hi Ritchie,

the database file is OK & still can be opened by MS Access 2007!!

 

[Douglas J. Steele]

That's true, but all you should have to do is change the reference to the
appropriate one. Since the Access 2007 database is still in mdb format,
changing the reference to Microsoft DAO 3.6 Object Library should be
sufficient.