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 some of 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 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

Hi, Anthony.

You aren't joined to the secure workgroup information file that was used to
secure the database.  Find this file and then join it for the session by
using a Windows shortcut with the following syntax (watch out for word wrap,
as this should be all one line):

"C:\Program Files\Microsoft Office\OFFICE\MSAccess.exe" "C:\Data\MyDB.mdb"
/wrkgrp "C:\Data\Secure.mdw"

When converting from an earlier version, it's best to log into the secure
database as the owner of that database, remove security, close the database,
then convert to the new version, then reapply the same security permissions.
To make it a little easier, use Sandra Daigle's DBUtilities utility to copy
the permissions from the old database to the new Access 2003 database.

http://www.daiglenet.com/MSAccess.htm

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


Show quoteHide quote

How Do I Prevent Access 2003 Crash when using Digital ID & Library
User level security 2002 / 2003
Design Master security
workgroup information file (WIF) problem
logon
security applied to all my DBs
digital signature trouble
Providing logins for users and filtering records based on users
Backend DB Password
access security