Software

Ask something
Discussion Locked

Permission needed to open Access DB

0 helpful
3 replies

by jamrock 3 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a W2K server Spk4, Users wksta Win XP Spk1, MS Office XP (Access). Error Msg " You do not have the necessary permissions to use the object. Have your system administrator or the person who created this object establish the appropriate permissions for you. When user try to open DB.

1. The User has full permission and Ownership. and she still gets the error.

2. I gave Administrator full control and ownership
and get the same error when try to open it under administrator.

Will apprciate any help.

Thanks.

3 replies

by r. diel

Sounds like the DB is setup to allow multiple user. You will have to find the appropriate *.mdw file. If the DB is stored locally, search the HD for *.mdw files. Access uses system.mdw for normal ops, but a DB for multiple users requires a separate *.mdw. If stored on a file server, check there for the *.mdw file. Once you find the *.mdw file, open Access and go to Tools, Security, Workgroup Admin, click Browse and browse to the location of the *.mdw file, click Open then Join. You should get a Message saying you successfully joined X Workgroup. You may have to create a user account inside Access, and you can do that from Tools, Security, User and Group Accounts. Click the new button and create a user account with appropriate permissions. The user account will be created with a blank password. Once you have done that, try and open the DB again, it should then start with a password dialog with the user's name, just click OK and the user should be in the DB. You might have to find the original creator of the DB if possible if you have other problems, because the creator may have built further limitations into the VB code for the DB. HTH.

This discussion is closed to new replies.