Problem with Access 2000 Security

[Ahmed]

Hi,

I'm working on an MS Access 2000 database. I created a workgroup file
while inside of a database, and it works perfectly for that database.
My problem is that I have a couple other unsecured databases that I
would like to secure. Now it was my understanding that if I used the
Workgroup Administrator to join my newly created security workgroup
(call it ACT), I would be able to create a new database and have it be
secured by the same workgroup file. However, after creating the new
database, closing it, and then rejoining the normal SYSTEM.MDW file, I
can open the newly created database without being prompted for a ID
and password. If I try to open the original database, that I had open
when I created the workgroup file, it correctly says that I don't have
permission to access that original database. What gives? Any help is
greatly appreciated.

Thanks,
Ahmed

 

[Lynn Trapp]

If you rejoined the SYSTEM.MDW file, but created the security with another
MDW file, then you should NOT be able to open your secure database. You need
to create a shortcut that points to the secure.mdw file. The general syntax
is:

"PathToMSAccess.exe" "PathToDatabase.mdb" /wrkgrp "PathToSecure.mdw"

 

[Joan Wild]

Just to emphasize it, using the shortcut will use your 'secure' mdw, however
if you can open your mdb using system.mdw, then it isn't secure.

 

[Alfred Nash]

Ahmed.
I consider myself an expert on this subject.

When you created your new databases while joined to the new MDW you still
have to open the MDB and remove permissions to the database from the user
'Admin' and remove the Admins Group from the Admin user.

Before you do that be sure you have a seperate login that is a member of the
Admins group and log in with that user name before you create the new
databases.

Recap steps on how this is done.

Create a new workgroup
Join it if you wish.
Create a user name.
Assign that username to the Admins group.
Set a password for the Admin user.
Close Access and reopen using the new username. NOT Admin.
Create a new database.
Remove Admin user from Admins Group.
Remove permissions to open database from Admin and the USERS group.
Remove permissions from all objects for user Admin and group Users
Create a username for normal users and set permissions accordingly including
Database Open
Import all objects from unsecured database.
Close Access rejoin System.mdw and try to open new database.
You should get an error telling you that you do not have permissions.


There are shortcut methods you can use so you can use both secure and
unsecured databases without having to rejoin a workgroup everytime.

Enjoy