Access 2002 User Level Security Problem (repost from other forum)

[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 has no access, but if a user creates their own MDW, joins it, then manually opens my MDB they have total control, which is a bad thing. I have tried removing all permissions from the Admin account to no avail.

Can someone pleae help?

 

[NorthNone]

- Thanks for the info that this happens both on and off the network (other posting)
- I found an article on Microsoft's site that isn't exactly what you are describing, yet it DOES recommend that you recreate your security in XP instead of trying to upgrade the security you had in 97 due to many improvements in security:

http://support.microsoft.com/default.aspx?scid=kb;en-us;282357

When you successfully re-secure the database I suspect your problem will be corrected.
ALSO, check out Frequently Asked Questions on this site about security.
FAQ:

http://www.tek-tips.com/faq.cfm?pid=181

HTH
JSouth

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