how due I unsecure a database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that I setup security that it prompts for user id and
password. I would like to turn off that feature so that anyone can go in and
modify the database - we no longer have a need for turning on the security.

How do I get rid of the prompting for user name and allow people to get in
and modify with out that.

Thanks,
Barb
 
babs said:
I have a database that I setup security that it prompts for user id
and password. I would like to turn off that feature so that anyone
can go in and modify the database - we no longer have a need for
turning on the security.

How do I get rid of the prompting for user name and allow people to
get in and modify with out that.

Thanks,
Barb
Click to expand...

Open and login as a user with administrative rights. Once in give full
permissions on all objects to the group "Users". That's pretty much it, but
if you wanted to be a bit more thourough you could then close Access and
then open it with the default workgroup (one that does not ask you to log
in). Then create a new blank file and import into it all of the objects
from your existing file. That should work after giving "Users" permissions
to everything. That will make "Admin" the owner of all objects which is the
case on a file that was never secured in the first place.
 
Back
Top