Can't Open Database Error 3041

[MartinLiss]

I use the following DAO code to open a database

DBEngine.SystemDB = GetWindowsDir() & "WIZARD.MDA"
    DBEngine.DefaultUser = "MyUserName"
    DBEngine.DefaultPassword = "MyPassword"
    gsRWTSPath = App.Path & "\data\rwts.mdb"
    Set gdbRWTS = Workspaces(0).OpenDatabase(gsRWTSPath)

After literally years of maintaining this application I'm suddenly getting error 3041 which says "Can't open a database created with a previous version of your application". What in the world is going on? (I can't find any reference to the 3041 error in help.)

[techgnome]

By any chance was Access reciently upgraded? That error message looks similar to the message Access displays when a DB has been updated to a newer version, then an attempt is made to open it in an older version.
IE: DB was created using Access2K, "upgraded" to AccessXP, then tried to open it using Access2K....
For some reason, MS in their infinite wisdon didn't maintain backwards compatibility. Once an Office doc (Word, PP, Access, XL) is converted to XP, there's no going back.


Just a guess tho.

[MartinLiss]

No updates, at least not intentionally.

[goatsucker]

What about database corruption? I must admit I have not seen that error turn up due to a Jet 3.x database corrupting, but it might be worth repairing the database. It is the sort of thing that can turn up out of the blue.

[MartinLiss]

I tried that already. It seems that it has something to do with the MDA file because when I bypass the DbEngine stuff I can open the main database. That doesn't do me any good however because the tables are password protected and so I can't read them without executing the DbEngine code.

Any idea how to create an MDA file? I must have done it before since one exists for this app, but I don't remember how.

[TPR25]

I'm not sure if this helps, but this is from the MSDN Knowledge base:

http://support.microsoft.com/default...;en-us;q152216

[MartinLiss]

I just tried to open the MDA file using Access itself and I get the same error.

[PhilRob56]

Early versions of Access use an MDA file, with Access 97 and later using an MDW file for security.

If Access is installed then look for a file called WRKADM.EXE (or similar name) in your Windows System directory.
You use this file to create or join the Workgroup. You will probably need to rename the existing MDA file first..(sorry for stating the obvious )

[MartinLiss]

Originally posted by TPR25
I'm not sure if this helps, but this is from the MSDN Knowledge base:

http://support.microsoft.com/default...;en-us;q152216

Thanks, it confirms my belief that I may need to reinstall Acess.

[MartinLiss]

Originally posted by PhilRob56
Early versions of Access use an MDA file, with Access 97 and later using an MDW file for security.

If Access is installed then look for a file called WRKADM.EXE (or similar name) in your Windows System directory.
You use this file to create or join the Workgroup. You will probably need to rename the existing MDA file first..(sorry for stating the obvious )

I'm familiar with the Workgroup Administrator (wrkadm). I have an MDW file that is associated with another app. When I use the Workgroup Administrator and join either that MDW file or my MDA file I get the same error message when I try to start Access! I can however join System.MDW. What do I do from there?

[MartinLiss]

I just uninstalled Acess 97 and reinstalled it. No help