Password Protected database that doesn't let me in?

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

Guest

Getting message "you do not have necessary permissions to use object. Have
system administrator establish appropriate permissions. I am the
administrator-tried to update wizards on Access 2000 and now can't get into
my database. Help!!
 
Your problem may be related to Windows file security. Check to make sure you
have proper permissions on the folder that the database is stored in.
 
Locked said:
Getting message "you do not have necessary permissions to use object.
Have system administrator establish appropriate permissions. I am the
administrator-tried to update wizards on Access 2000 and now can't
get into my database. Help!!
Click to expand...

You'll get that message if you are trying to open a database while using the
wrong workgroup file.

Your subject says password protected, but do you mean database password
(password prompt), or user level security (username and password prompt)?
Did you secure this database? If so, you need to use the correct workgroup
file - the one you secured it with.
 
The alert we are getting says "you do not have necessary permissions to use
object. The workgroup files are in Access and Access won't allow us in. We
also have tried both administrator & user level security passwords to open
files and it won't open.
 
Locked said:
The alert we are getting says "you do not have necessary permissions
to use object. The workgroup files are in Access and Access won't
allow us in. We also have tried both administrator & user level
security passwords to open files and it won't open.
Click to expand...

It won't allow you in because either
1. you are using the wrong workgroup
or
2. you are using the correct workgroup, but logging in as a user that
doesn't have permissions.

What workgroup are you joined to by default (check using the workgroup
administrator)?
Do you use a desktop shortcut to start the database; if so what is in the
target?

It sounds to me as though the database is secure, but you are trying to open
it by just double-clicking it in Windows Explorer. Your computer is joined
by default to system.mdw and you therefore are logging in (silently) as
Admin. The Admin user does not have permissions for your secure database
(and the Admin user shouldn't have permissions).

You need to create a desktop shortcut with this in the target:

"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to mdw you secured
it with"
 
It sounds to me to be related to 'license' permissions for an Object Library.
Have you updated and References or Controls lately?
 
Back
Top