Ungent help

  • Thread starter Thread starter Jie
  • Start date Start date
J

Jie

Hello, I am a new user of MS Access. Anybody can help me?
I set our office's database with a user and group
permission because we had a couple of people to log in,
and a security file was created automatically as well.
From that time, every time if I wanna open the database, I
have to use shortcut to open it(if i click the database
file directly, it won't work) However, we dont need so
many username right now, so is there any chance I can
unset the permission as I did before, so I can open the
database file directly? Please let me know. Thank you very
much.
 
- Click on the shortcut and log in to the database with the
administrator account.
- Go to tools > security > user and group security
- Add the Admin account to the Admin Group and clear the password of
the Admin account. Once the admin account has an empty password, you
will not be asked for a username and password and you can open the
database directly without the shortcut.
- Go to tools > security > user and group permissions and make sure
that the Admin user has full control and ownership of the database
objects.

Now try to click on the database and it should give you full access
without a log-in prompt.


Ed
 
Hello, I did read it and removed the users, however,
right now when I open the database, I still have to
depend on the shortcut to open it. If I open the database
directly, it will say "You do not have necessary
permission to use Database.mdb object. Have your
administrator establish the approciate permission for
you". I am lost. Could you help me again?

Thank you very much
 
Hello, I did read it and removed the users, however,
right now when I open the database, I still have to
depend on the shortcut to open it. If I open the database
directly, it will say "You do not have necessary
permission to use Database.mdb object. Have your
administrator establish the approciate permission for
you". I am lost. Could you help me again?

Thank you very much
 
You didn't read it fully, then. There's more to it than removing the users.
You need to give full permission back to the Users Group for all objects
(don't forget the database object).

Then open Access using the standard system.mdw workgroup, and create a new
database and import all the objects from your mdb.
 
Back
Top