You do not have necessary permissions

[Guest]

When I try opening a database, I get the message "You dont have the necessary
permissions..." and I cant open it. But I am able to open another database
also in 'My Documents', I am able to. I understand from another note here
that databases are not "linked" to workgroup files and Access chooses the
workgroup file even before it opens a database. If thats the case, why is one
database able to open and another not able to. How can I open the one which I
am not able to

 

[Joan Wild]

Your first database is secured using a workgroup file (mdw) other than your
default. Your default mdw does not have a user that has permissions to your
database.

Check what workgroup file you are joined to by default (Tools, Security,
Workgroup Administrator). It likely is system.mdw usually located in the
windows system folder.

Then use Start, Search and locate all the mdw files on your computer. Your
first database likely needs to use one of these. Create a desktop shortcut
to launch the database using the correct mdw file. The targer of the
shortcut would look like:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

 

[Guest]

Hi.

When I try opening a database, I get the message "You dont have the necessary
permissions..." and I cant open it.

That means you are not joined to the secure Workgroup before opening the
secure database. Either use the Workgroup Administrator to permanently join
the secure Workgroup or (better yet) use a shortcut with the workgroup file
included in the command line argument. Please see the tip "How to open
databases and only be prompted for User ID and password for the secure
databases" for instructions on how to create the shortcut on the following
Web page:

http://www.Access.QBuilt.com/html/security.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.