Converting Access 97 Databases to Access 2003 with read only macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ant - 10 Jul 2006 00:50 GMT

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

Reply to this Message

Allen Browne - 10 Jul 2006 06:35 GMT

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"

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I'm trying to convert an Access 97 database to Access 2003 how ever I get
> an
[quoted text clipped - 14 lines]
>
> Anthony

Reply to this Message