Access 2007 security and the Access 2003 system.mdw file

16 Mar 2009 2:41 PM

DP

I have several Access 2003 databases with database and user and group level
security in place. From what I have read Access 2007 should be able to work
with these databases in their native 2003 format. Yet when I attempt open
these databases I receive the error - "You do not have the necessary
permissions to use the <name> object. Have your system administrator or the
person who created this object establish the appropriate permissions for you.
(Error 3033)" My System.mdw file from Access 2003 is on a network share and
all installations of Access 2003 were forced to use it by group policy. I
have made sure that Access 2007 has the locations of the workgroup file and
the databases added to the trusted locations area although my understanding
on the workgroup file is that Access 2007 does not use it but does emmulate
the functionality. Any help would be appreciated.

16 Mar 2009 3:24 PM

Joan Wild

Is the 'system.mdw file from Access 2003' actually the secure mdw?

You need to make the secure mdw available to users and then give them a
desktop shortcut to start the database.

"path to 2007 msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

Joan Wild
MS Access MVP

DP wrote:
Show quoteHide quote

> I have several Access 2003 databases with database and user and group level
> security in place. From what I have read Access 2007 should be able to work
> with these databases in their native 2003 format. Yet when I attempt open
> these databases I receive the error - "You do not have the necessary
> permissions to use the <name> object. Have your system administrator or the
> person who created this object establish the appropriate permissions for you.
> (Error 3033)" My System.mdw file from Access 2003 is on a network share and
> all installations of Access 2003 were forced to use it by group policy. I
> have made sure that Access 2007 has the locations of the workgroup file and
> the databases added to the trusted locations area although my understanding
> on the workgroup file is that Access 2007 does not use it but does emmulate
> the functionality. Any help would be appreciated.