PLEASE HELP!!!

  • Thread starter Thread starter Jenn
  • Start date Start date
J

Jenn

I have created a database with a user-level security, but
it was not working correctly. I tried to remove the user-
level security from the database, but it will not allow me
to try and enter a username and password to enter the
database. It gives me the following error:

You do not have the necessary permissions to use
the 'C:\WINDOWS\Desktop\AARC.mdb' object. Have you system
administrator or the person who created this object
establish the appropriate permissions for you.

The problem is that I am the administrator and I created
the object.

Is there any way that I can completely remove the user-
level security and start over again with out loosing the
data or layout of the database?

Thanks!!
 
You say it does not allow you to enter your user name/password. That
leads me to believe that you are not logging onto the workgroup that the
database is tied to.

Do you know where that workgroup is? The name should end with .mdw.

If you do, try adding the following to a shortcut to the database in the
target line of the properties box.

Nameofdatabase.mdb /wrkgrp N:\foldername\wrkgrpname.mdw

* Where "Nameofdatabase.mdb" is the name of the database (it should
already be there)
* Where "N:\foldername\" is the full path to the workgroup file and
"wrkgrpname.mdw" is the name of the workgroup.

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 lock
everyone including God out.

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