How do I secure only one access database

[Stapes]

Hi

I am trying to put user names & passwords on one of the Access
databases I am working on. I have begun working through the steps to
protect it, but now it seems to be affecting access to all my other
Access databases. Is there any way I can restrict it to the one
database? I need to do this now before I continue working on this
current project, as it affects my other clients databases.
So far I have created a workgroup, created a new user name & password
for the Admins group and removed Admin from the Admins group.

Stapes

 

[Mikey C]

What you need to do is create a new workgroup file (you can use the
security wizard), instead of amending your default workgroup file
(Security.mdw). If you make changes to this file it will apply to any
Access database opened on your system.

Now, to open your database with your new workgroup file you need to
create a link with the following code (example):

(Target) "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
**(fielpath to MS Access)** /wrkgrp "S:\Competitor Analysis DB\CA
Database\NewUser Set-Up\Security.mdw" **(filepath to .mdw)**
"C:\Program Files\Competitor Analysis Database\Competitor Analysis
Database (FE)" **(filepath to db)**

(Start in) "C:\Program Files\Competitor Analysis Database" **(file
containing database)**

Remove permissions for Admin users (or anyone can access database with
default .mdw)

You can find the process in more detail at
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

Good luck - hope it helps!

 

[Joseph Meehan]

Hi

I am trying to put user names & passwords on one of the Access
databases I am working on. I have begun working through the steps to
protect it, but now it seems to be affecting access to all my other
Access databases. Is there any way I can restrict it to the one
database? I need to do this now before I continue working on this
current project, as it affects my other clients databases.
So far I have created a workgroup, created a new user name & password
for the Admins group and removed Admin from the Admins group.

Stapes

As indicated using user level security you likely want to have a
separate workgroup file.

However, have you considered using standard password security? You can
set up a password security in Access without using user level access. The
security is weak and it lacks many of the features of use level security,
but if you needs are not complex and you don't need really security, it may
be a better tool.