User-Level Security Wizard

[Computer geek]

I recently used the User-level security wizard on an access database
for the first time. After following all the steps and adding a user
name for myself and a couple others, I closed the database and tried
to re-open it. When I tried opening it I got a message saying "You do
not have the necessary permissions to use the [databasename.mdb]
object. Have your system administrator or the person who crated this
object establish the appropriate permissions for you." Any ideas on
what I may have done wrong? Or how I can fix it?

 

['69 Camaro]

Hi.

Any ideas on
what I may have done wrong? Or how I can fix it?

You are currently joined to a workgroup that wasn't used to secure the
secure database. In some versions, the wizard creates a shortcut for you,
but I think you have to press the button to accept this shortcut's creation.
Otherwise, you'll have to create the shortcut yourself, which temporarily
joins you to the secure workgroup for the session, allowing you to login in
with your User ID and password. Try the following syntax for the target
(all one line):

"<Full path to Office>\MSAccess.EXE" "<Full path to DB>\MyDB.MDB" /wrkgrp
"<Full path to secure workgroup>\Secure.MDW"

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

I recently used the User-level security wizard on an access database
for the first time. After following all the steps and adding a user
name for myself and a couple others, I closed the database and tried
to re-open it. When I tried opening it I got a message saying "You do
not have the necessary permissions to use the [databasename.mdb]
object. Have your system administrator or the person who crated this
object establish the appropriate permissions for you." Any ideas on
what I may have done wrong? Or how I can fix it?

 

[John W. Vinson]

I recently used the User-level security wizard on an access database
for the first time. After following all the steps and adding a user
name for myself and a couple others, I closed the database and tried
to re-open it. When I tried opening it I got a message saying "You do
not have the necessary permissions to use the [databasename.mdb]
object. Have your system administrator or the person who crated this
object establish the appropriate permissions for you." Any ideas on
what I may have done wrong? Or how I can fix it?

Download and read the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Read it *thoroughly*. Get a good night's sleep. Read it thoroughly
AGAIN.

It's very easy to get security wrong, and the wizard isn't terribly
clever and can help you go down the wrong path. I hope you kept an
unsecured backup; you might be able to get this working... but it
might be tough.

John W. Vinson [MVP]

 

[Arvin Meyer [MVP]]

I recently used the User-level security wizard on an access database
for the first time. After following all the steps and adding a user
name for myself and a couple others, I closed the database and tried
to re-open it. When I tried opening it I got a message saying "You do
not have the necessary permissions to use the [databasename.mdb]
object. Have your system administrator or the person who crated this
object establish the appropriate permissions for you." Any ideas on
what I may have done wrong? Or how I can fix it?

In addition to Gunny's and John's answers, here are some shortcuts to other
excellent security sites run by MVPs:

Lynn Trapp's FAQ summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm

and some Microsoft KB articles:


KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261