Password Protected database that doesn't let me in?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Locked out - 03 Oct 2004 23:47 GMT

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!!

Reply to this Message

Lynn Trapp - 04 Oct 2004 12:45 GMT

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.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> 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!!

Reply to this Message

Joan Wild - 04 Oct 2004 14:32 GMT

> 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!!

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.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message

Locked out - 04 Oct 2004 16:25 GMT

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.

> > Getting message "you do not have necessary permissions to use object.
> > Have system administrator establish appropriate permissions. I am the
[quoted text clipped - 8 lines]
> Did you secure this database? If so, you need to use the correct workgroup
> file - the one you secured it with.

Reply to this Message

Joan Wild - 04 Oct 2004 18:07 GMT

> 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.

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"

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message

Locked out - 04 Oct 2004 16:13 GMT

Would you elaborate on this. The database is protected through Access.

Reply to this Message

jon stav - 04 Oct 2004 19:21 GMT

It sounds to me to be related to 'license' permissions for an Object Library.
Have you updated and References or Controls lately?

Reply to this Message