Help! I have a Microsoft Access 97 database that I have been accessing/adding/deleting/querying records from using VB 6 code. I have been opening the database using a standard DAO opendatabase command shown below where "db_location" and "database_password" are variables stored in code.

Set db = OpenDatabase(db_location, False, False, ";PWD=" & database_password & "")

Recently, this database was converted to Access 2000. Now, when trying to open the database via my VB code, I get a runtime error '3343 Unrecognizable database format' on the above opendatabase command. From the article below, this is to be expected. The proposed resolution to the problem is to download a special service pack from the location below that contains a dll file that needs to be referenced in your project ‘Microsoft DAO 3.6 Object Library’. I did this and now I get a ‘3633 Runtime Error’. Has anyone had the same experience? Any ideas on what to do next?

Article:

http://support.microsoft.com/support...G=ENG&SA=ALLKB

Service Pack Download:

http://msdn.microsoft.com/vstudio/sp...load.asp?id=10

Thanks
KBH