Security problems

[amy.dangas]

I need some help with either reseting my security features all
together or knowing how to log out. I inadvertantly neglected to give
all my users any privaledges and now you can open the program but no
one can look at anything. Any suggestions would be great thanks.

 

[Joan Wild]

You need to decide if you want to fix things so that users can look or edit
or whatever, or if you want to completely remove security.

If the former, login with your username and grant the necessary permissions
for the various Groups you set up. If you didn't set up any groups, then do
so and assign permissions to the group for various objects. As a minimum
each Group will need Open permission on the Database object and on Forms and
Reports. They'll also need Read Data permission on the recordsources of any
Forms and Reports (which may be queries or tables). If you want them to be
able to update/insert/delete records, you'll need to grant those permissions
on the recordsources as well.

If the latter, you'll need to login with your username and grant full
permissions to all objects to the Users Group. Use Tools, security,
workgroup administrator to ensure that you are joined by default to
system.mdw, the workgroup that ships with Access. Then quit Access, restart
it and create a new mdb; import all objects from your mdb.

 

[Joseph Meehan]

I need some help with either reseting my security features all
together or knowing how to log out. I inadvertantly neglected to give
all my users any privaledges and now you can open the program but no
one can look at anything. Any suggestions would be great thanks.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.