Converting Access 97 Databases to Access 2003 with read only macros

[Ant]

Hi,

I'm trying to convert an Access 97 database to Access 2003 how ever I get an
error message that Access 2003 can not convert the database due to
security reasons (some of the macros are set to read only) and quits.

When I look in the database in Access 97 some of the macros have a user of
'Unknown' rather than 'Admin'. I can't change the user 'Unknown' to 'Admin'
and the set
the macro permissions to full as user 'Admin' doesn't have the security
permissions for this, which means Access 2003 can't convert the database
because it can't access the macros.

Any Ideas?

Thanks for any help.

Anthony

 

[Allen Browne]

Can you create a new, unsecured Access 97 mdb, and import everything?
That new file should then convert okay.

You might even be able to create a new Access 2003 file, and import
everything:
File | Get External | Import
At worst, that should import all the objects that don't have the problem.

Another possiblity would be to export the macros from Access 97 to a text
file, and then import them into another unsecured mdb. Perform the export
with this kind of thing:
SaveAsText acMacro, "Macro1", "C:\macro1.txt"
and the import:
LoadFromText acMacro, "Macro1", "C:\macro1.txt"