VB6 Connection to Microsoft Access 2000
Posted on 2004-11-11
Can anyone help me?
I've read some of the answers to questions posted about this subject but can't find anything specific to this error message without becoming a 'paid again member'!
I'm exploring VB6 with the hope of creating an application that can connect to an Access 2000 database and hopefully eventually being able to go on from this to allow access to the database on the internet. I assume I should be using VB.net but haven't been able to afford that luxury yet so am still using VB6.
When I try to make the connection I get an "unrecognized database format" message.
Having created a DAO DataLink with the VB6 wizard I can 'see' the database. In the DataView window I can see the tables and field names but when I try to set the RecordSource property of the DataLink I just get the error message.
This problem only seems to occur with later versions of Access i.e. 2000/ 2002. I have succesfully connected to an Access 97 version of the same database.
I have downloaded and run 'acc2conv' from Microsoft and 'compacted and repaired' the database but neither of these actions has solved the problem.