-
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
-
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
-
-
here it is