General discussion

Locked

Permission needed to open Access DB

By jamrock ·
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 <file name> 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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by R. Diel In reply to Permission needed to open ...

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.

Collapse -

by jamrock In reply to

Great, it work

Collapse -

by jamrock In reply to Permission needed to open ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums