Access 2000 vs Access 97

[hall]

Help! I am a relative novice at this kind of thing so please bear with me. 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. There were no error messages or anything that would tell me that there was a problem during the conversion. Further, I can open up the database from within Access 2000, with no apparent problems. However, I can no longer open it with my VB code as I get a runtime error '3343 Unrecognizable database format' on the above opendatabase command. Any suggestions.

Thanks
KBH

[Chuck Sweet]

have no fear. service pack 4 was supposed to fix Access 97/2000 compatibility issues. i don't have the address right now, but you can get it from microsoft for nothing.
chuck

[Clunietp]

http://support.microsoft.com/support/kb/articles/q238/4/01.asp?LNG=ENG&SA=ALLKB

[kovan]

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