removing user level security

[Guest]

For various reasons, I want to remove the user level security for my db. I
went through the process as spelled out in the SECFAQ. My .mdb file will not
open on its own now, but will open as a shortcut with the path/.mdw in the
properties.

How can I remove the need for the .mdw file completely?

tia

 

[Lynn Trapp]

If you can only open the database using your shortcut, then that's a pretty
good indication that you secured the database properly. You CANNOT remove
the need for a .mdw file completely. You can desecure your database,
however.

1. Log in as a member of the Admins Group.
2. Add the Admin User to the Admins Group.
3. Give the Users Group full permissions to all objects in the database.
4. Remove the Admin User's Password.
5. Be sure you are joined to the system.mdw file that shipped with Access.

 

[Guest]

Thanks for the quick reply!

I checked "Administer" on all db objects (didn't realize just how many there
were) and that made the difference.

thanks again,
JMorrell

 

[Lynn Trapp]

You're welcome.

 

[Guest]

Lynn - I am new to Access security - which I set by mistake and I need to
remove any security from the database. I have tried to follow your
instructions below but do not understand some of the terms.
1. How do I Log in?
2. I have looked at the "user and group permissions" and "user and group
accounts" and all seems correct. I can access the database with Access but I
cannot write (INSERT or UPDATE) from an ASP/ADO application - I get the
response.
Can you teach a novice how to overcome this.
Thanks
Dennis