Access 2002 User Level Security Problem 1

[arniec]

We have recently upgraded to Access 2002 from Access 97. I developed several databases with user level security, which users would access through shortcuts specifying the database's (MDB) path and the path to the database's specific security file (MDW). It was locked down under 97 so that if you tried to open the database without joining the specific workgroup first you would not be able to access any tables, forms, etc.

Now that we have XP I am unable to restore that setting. All user permissions are in tact in the MDW file, but now when you just double-click on the MDB file (opening it as Admin in the default MDW) the user is given complete access to view, modify, etc. I have tried removing all permissions from the Admin account to no avail.

Can someone pleae help?

 

[NorthNone]

Are these databases on a network?
If so, does the problem persist if you run them on your local hard drive?

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.

 

[NorthNone]

Also, you might want to restart this thread in Microsoft: Access Other topics instead of FORMS

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.

 

[arniec]

The database is on a network and the problem does persist on a local drive.

I have been able to lock out users who just double click on the MDB, but if a user creates their own MDW, joins it, then manually opens my MDB they have total control, which is a bad thing.