|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Admin does not have permission to use data baseEverytime I try to open my data base I get back the following message:
"You do not have the necessary permissions to use the "data base name" object. Have your system administrator or the person who created this object establish the appropriate permissions for you." I created the data base and I am signing on as Admin. Could someone have wiped out the admins permissions? If so, how do I correct this? Thanks! Apparently you implemented Access Security. Did you build a workgroup and
join it? If you did this, and if you used the security wizard, then the Admin user would no longer have any rights on the database. Normally you create another user and place that user in the Admins group. Did you do so? If you did, then log on as that user and setup other user accounts and such with that login. You can also try rejoining the default system.mdw workgroup file. To find out what workgroup you're currently joined to, do this; Access 2002/2003 ============== Open Access, but don't open any database. Click Tools - Security - Workgroup Administrator Access 97/2000 =========== Do a filesearch for "wrkgadm.exe" and run it. In either case, you'll find out which workgroup file you're joined. To rejoin the system.mdw file: Do a filesearch for "system.mdw". Using one of the methods above, run the Workgroup Administrator, and click "Join" and join the system.mdw file found earlier. Generally speaking, it's a good idea to setup a desktop shortcut to log onto your secured database. To do that, create a new shortcut and set this as the Target: "FUll path to MSAccess.EXE" "Full path to your db" /wrkgrp "Full path to your workgroup file" Here's a link to the MS whitepaper regarding Access security: http://support.microsoft.com/Default.aspx?scid=http://support.microsoft.com/support/access/content/secfaq.asp Show quote "kevin" <ke***@discussions.microsoft.com> wrote in message news:0DD52BCB-E52D-4623-BE57-F4F4822CC7DF@microsoft.com... > Everytime I try to open my data base I get back the following message: > > "You do not have the necessary permissions to use the "data base name" > object. Have your system administrator or the person who created this > object > establish the appropriate permissions for you." > > I created the data base and I am signing on as Admin. Could someone have > wiped out the admins permissions? If so, how do I correct this? > > Thanks! Scott:
Thanks for the reply. I was working on a different PC on the network trying to build a short cut on the desktop back to the data base PC. I copied over the workgroup and joined it. And yes I used the Access Security, (which may or may not have been right). Problem is I can't access the data base on the original PC will I am sitting at it. In fact the error message comes up just trying to open from the shortcut. You don't even get a chance to enter an User and password. I am working with Access 2000 BUT the data base was originally built in Access 97. I tried removing all the workgroup files which open up all the back-up copies but I still can't gain access to the current version of the data base. I tried copying the data base and loading it on another stand only computer but still get the same error message. If Admin can't open the file and I am given no chance to enter a User Id and password how do I get around this "lock" and retreive my data? Show quote "Scott McDaniel" wrote: > Apparently you implemented Access Security. Did you build a workgroup and > join it? If you did this, and if you used the security wizard, then the > Admin user would no longer have any rights on the database. Normally you > create another user and place that user in the Admins group. Did you do so? > If you did, then log on as that user and setup other user accounts and such > with that login. > > You can also try rejoining the default system.mdw workgroup file. To find > out what workgroup you're currently joined to, do this; > > Access 2002/2003 > ============== > Open Access, but don't open any database. Click Tools - Security - Workgroup > Administrator > > Access 97/2000 > =========== > Do a filesearch for "wrkgadm.exe" and run it. > > In either case, you'll find out which workgroup file you're joined. To > rejoin the system.mdw file: > > Do a filesearch for "system.mdw". Using one of the methods above, run the > Workgroup Administrator, and click "Join" and join the system.mdw file found > earlier. > > Generally speaking, it's a good idea to setup a desktop shortcut to log onto > your secured database. To do that, create a new shortcut and set this as the > Target: > > "FUll path to MSAccess.EXE" "Full path to your db" /wrkgrp "Full path to > your workgroup file" > > Here's a link to the MS whitepaper regarding Access security: > http://support.microsoft.com/Default.aspx?scid=http://support.microsoft.com/support/access/content/secfaq.asp > > "kevin" <ke***@discussions.microsoft.com> wrote in message > news:0DD52BCB-E52D-4623-BE57-F4F4822CC7DF@microsoft.com... > > Everytime I try to open my data base I get back the following message: > > > > "You do not have the necessary permissions to use the "data base name" > > object. Have your system administrator or the person who created this > > object > > establish the appropriate permissions for you." > > > > I created the data base and I am signing on as Admin. Could someone have > > wiped out the admins permissions? If so, how do I correct this? > > > > Thanks! > > > kevin wrote:
> In What is in the target of this shortcut?> fact the error message comes up just trying to open from the > shortcut. You don't even get a chance to enter an User and password. -- Joan Wild Microsoft Access MVP Joan, per Scott's original message:
"Generally speaking, it's a good idea to setup a desktop shortcut to log onto your secured database. To do that, create a new shortcut and set this as the Target: "FUll path to MSAccess.EXE" "Full path to your db" /wrkgrp "Full path to your workgroup file"" ....that is the shortcut. Max... Show quote "Joan Wild" wrote: > kevin wrote: > > > In > > fact the error message comes up just trying to open from the > > shortcut. You don't even get a chance to enter an User and password. > > What is in the target of this shortcut? > > -- > Joan Wild > Microsoft Access MVP > > > Hi Max,
You've confused me. The original post is from 'kevin'. Who is Scott? (and this thread is over a month old; are we still talking about the same problem? Show quote "Max" <M**@discussions.microsoft.com> wrote in message news:0E897B21-C763-4B32-9822-CC0A9BDF48CF@microsoft.com... > Joan, per Scott's original message: > > "Generally speaking, it's a good idea to setup a desktop shortcut to log > onto > your secured database. To do that, create a new shortcut and set this as > the > Target: > > "FUll path to MSAccess.EXE" "Full path to your db" /wrkgrp "Full path to > your workgroup file"" > > ...that is the shortcut. > > > Max... > > "Joan Wild" wrote: > >> kevin wrote: >> >> > In >> > fact the error message comes up just trying to open from the >> > shortcut. You don't even get a chance to enter an User and password. >> >> What is in the target of this shortcut? >> >> -- >> Joan Wild >> Microsoft Access MVP >> >> >> -- Joan Wild Microsoft Access MVP  |
|||||||||||||||||||||||
Other interesting topics