security issue with DB

[TracyG]

How can you get around security setups on an access db. The initial
developer of the DB is now gone from the company and he left without telling
us the admin password - there is one user setup that does not have all
access to the DB. When I work with the DB on my own workstation it assumes
I am logging in as admin - but when the user tries to use it - it somehow
knows she's not the admin user - How does security work and how can you get
it to where there's really no security on the DB? There's really not a need
at the DB level at this point.

 

[Mark Mark]

If you check back later, I am sure a Microsoft rep will
respond, but as a user I found the best way to remove
security is to create a new master database and import the
necessary tables. Then create new database and import the
forms and queries used for the front end. (You will need
to create new links from the front ends to the master
file.

Security in Microsoft Access has never been worth the
hassel in my book. Instead I rely on folder rights.


Good Luck,
Mark

 

[Pieter Wijnen]

on the user's machine the admin user has been set up with a password (the
only way to force access to ask for one)
just replace the system.mdw file in her %windir%\system32 directory with a
fresh copy. Do make a backup first (since it might have been
changed/replaced for a reason)

HTH

Pieter

 

[Van T. Dinh]

Just a small correction: Microsoft reps don't usually respond in these
newsgroups. Most replies are from volunteers sharing their knowledge of
Access.