INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...This was the ONLY place that I could find information that I could use to resolve the problem. So thanks once again to member TomSark and the SQL forum!..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Microsoft: Access Reports Forum

Access Database Security

Read More Threads Like This One

tsm1993 (Programmer)

18 Apr 12 23:26

I have all of a sudden started getting an error trying to open an database. I get the following error:

"You do not have the necessary permissions to use the "..." object. Have your system administrator or the person who created the object establish the appropriate permissions for you"

I have tried opening on multiple pc's using different versions of both the mdw security file as well as the access database.

Has anyone seen anything like this and have any suggestions?

Thanks

lameid (Programmer)

19 Apr 12 13:25

Not sure if this is an Access security issue or Filesystem security issue.

Ensure that everyone has the same read and/or write permissions to the folders and file(s).

Assuming it is not file system...
If you haven't already.... Compact/Repair

Best bet is to go to a backup. I trust this is a Front End file and you won't lose data and you have backups...

Another less good option: Import everything to a new file with a user that has read design and read data permission to everything and set permissions in the new file.

tsm1993 (Programmer)

19 Apr 12 13:54

It appears my security file was corrupt. I am not sure what caused it and had tried replacing it multiple times, but on the last try, it suddenly opened. Yes, it was a front end and I did have back-ups of both the front end as well as the mdw file. Thanks.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft: Access Reports