user permissions

[nmbearman]

I would appreciate it if you could help me out. I inherited a database that
has user permissions set-up throughout. I don't have access to the Admin or
Administrator password or rights. I am a user, but want to free up all
access rights. Is there anything I can do to have total control of this
Database?

Thanks!

 

[Tom van Stiphout]

On Tue, 25 Aug 2009 14:00:03 -0700, nmbearman

No. User-Level Security (ULS) wouldn't be any good if average users
were able to do that. From the Security FAQ which you can download
from microsoft.com:
You must have Administer permissions and/or be a member of the Admins
group in the workgroup information file that the database was secured
with.

So you'll want to talk to someone with these elevated permissions.
If such person is not available, you have a couple of ways to proceed:
* Find a copy of the database that is not secured.
* Under the assumption that few people apply ULS correctly, find a
flaw and attack it.
* Find a password cracker (for ULS, *not* for the database password)

-Tom.
Microsoft Access MVP

 

[nmbearman]

I read somewhere that Ms. Wild stated the permissions do not travel with
inports and exports. Can I recreate the entire db by exporting all the forms
queries and tables to a new db?

 

[Joan Wild]

Why not try it an see? It will depend on the permissions you have when
you login to the database.

Joan Wild
MS Access MVP

 

[Tom van Stiphout]

On Wed, 26 Aug 2009 08:22:01 -0700, nmbearman

Joan is right: try it. That would follow my suggestion #2.
On a properly secured db it will not get you very far. Also, such db
would be an MDE rather than MDB so you still need to find the original
source code if changes were ever needed. A company MUST keep their
MDBs safe.

-Tom.
Microsoft Access MVP