Share via

MS Access Question... Error 3033

Anonymous
2011-06-14T17:35:52+00:00

MS Access Question... Why after restoring older file from our server the security.mdw defaults to the last log in and password where the problem was... you do not have the necessary permission to use the 'xxx.mdb' object'. have your system administrator... establish the appropriate permissions for you. problem i am the admin. can not get pass this error.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-06-21T09:07:35+00:00

Hi,

It prevents the login prompt from popping up. This means you are silently logged in as 'Admin', and it's likely that this user doesn't have permission to open the mdb.

To remove security properly...

  1. put a password back on the Admin user
  2. close Access and reopen your database using the proper mdw and logging in

as a member of the Admins group.

  1. Give full permissions on all objects to the Users Group.
  2. Close Access and reopen it using the standard system.mdw (no login)
  3. Create a new mdb and import all objects from your mdb.

This new mdb will be unsecured

Sincerely

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest