Unrecognised database format

Im trying to use the VB Dataform Wizard to create a form in vb6. However
when I select an Access 2000
database as my source I get the message "Unrecognised database format
'c:\databasenameandpath'". When
I select an Access97 database it works.
Does anyone know why? Is it to do with my settings in Access?

Thanks
Ian

Ian Davies wrote:
 > Im trying to use the VB Dataform Wizard to create a form in vb6.
However
 > when I select an Access 2000
 > database as my source I get the message "Unrecognised database format
 > 'c:\databasenameandpath'". When
 > I select an Access97 database it works.
 > Does anyone know why? Is it to do with my settings in Access?
 >
 > Thanks
 > Ian

Hi Ian,
Can you open the Access 2000 database in Access? In my experience,
that message means either the database is corrupt or the wrong ADO
provider is used. For a corrupt database, open it in access and do a
compact and repair. For the wrong ADO provider, make sure that your
connection string includes "Provider=Microsoft.Jet.OLEDB.4.0". By
saying 4.0 vs 3.51, you can open XP, 2000 or 97. if you have 3.51 you
can only open 97.

David Hodgkins<!-- ~MESSAGE_AFTER~ -->