I am assuming you mean she setup Access user level security on the machine.
Generally Admin is disabled, however she should have assigned someone as a
member of the Admins group. If she did not, then you can't set permissions.
If you are not talking Access induced security and just windows security,
then all she has to do is give everyone read/write/change at the Windows
level. Many IT people are not aware that users must have write privileges to
the database and folder where the database resides. This is so that a
locking ldb can keep track of locking.
You don't specify which version of Access you are using. Depending on the
version and if she used the Security Wizard within Access, then there should
be an unsecured copy of your database made to which you can use to reapply
security. However. MAKE A COPY AND HIDE IT SOMEWHERE BEFORE SHE TRIES AGAIN!
Another question? After creating the security, did she join everyone to the
secured.mdw file that was created. If you do not get joined to this mdw
file, you won't be able to properly logon and edit the database.
Security in Access can be tricky. If it is not done properly the first time
around you can lock everyone out from the database.
Recommended reading:
http://support.microsoft.com/default.aspx?scid=kb;en-us;165009&Product=acc2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;235961&Product=acc2000
Bill said:
One of my IT people was setting permissions for everyone, she created
different users and groups and set permissions for everyone, she gave admin
no permissions. The problem is that she didn't give anyone administer
permissions. At this point we can use the database as before but we can't
add or change anything. Is there any way to give someone permissions now?
