msysmodules2 error when trying to compile

[Don]

When I try to create a mde of an access 97 application I get the following
error.
"msysmodules2 isn't a valid account name". I've never seen this error in
the past. Only thing, I can think of is that I installed Access 2003 last
week on my machine. Anyone have a clue how to fix this?

Thanks

Don

 

[Graham Mandeno]

Hi Don

Are you using Access 97 or Access 2003 when the error occurs? If you are
trying to use 2003 to create an MDE from a 97 database, then try converting
the database to Access 2003 format first.

MSysModules2 was a hidden system table that Access 97 used to store the VBA
source code. After Access 2000 the code is stored in a VBA project, so that
table is no longer required.

Is the database secured with a workgroup file? If so, then the following KB
article might shed some light: http://support.microsoft.com/?id=170696