PC Review


Reply
Thread Tools Rate Thread

Access 2007 security and the Access 2003 system.mdw file

 
 
DP
Guest
Posts: n/a
 
      16th Mar 2009
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.
 
Reply With Quote
 
 
 
 
Joan Wild
Guest
Posts: n/a
 
      16th Mar 2009
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:
> 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.

 
Reply With Quote
 
masterminx
Guest
Posts: n/a
 
      1st Apr 2009
I'm getting that same error when I import a SharePoint list. I have full
control of the list, and I'm getting it on one list out of 3 on the same
site. Any ideas?

"Joan Wild" wrote:

> 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:
> > 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.

>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Access 2003 User Security DB opening with Access 2007 Donna Microsoft Access Security 4 20th May 2010 05:58 PM
Convert Access 2003 with security to Access 2007 Roxana Microsoft Access 2 2nd Jun 2009 03:46 PM
Access 2007 Security to Access 2003 Specific User Form Access Microsoft Access Security 0 2nd Apr 2008 01:04 AM
Access 2003 file opens to a blank page when opened in Access 2007 Vegas Van Microsoft Access 1 17th Feb 2008 08:28 AM
Don't need security in Access 2007 or Access 2003 OldManEd Microsoft Access Security 3 23rd Mar 2007 03:32 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:56 PM.