Security disappears with removal of MDW

[Daniel]

Hello,

I have tried to implement Workgroup based security by doing the following...

Create and join unique workgroup (filename Database.MDW)
Create user with admin privileges and assign password
Remove admin privileges from user 'Admin'
Strip User group of all permissions.
Create blank database
Import tables, forms and reports from existing database I want to secure

At this stage, authentication & permissions work as expected. When I delete
Database.MDW the 'secured' database opens up like a present on Xmas day. I
believe Access decides to use System.MDW in the absence of Database.MDW.

Any help given would be very much appreciated, thank you.


Kind regards,
Daniel.

 

[TC]

If you can open a secured db with any workgroup file *other than* the one
that you created it with, the security has not been put-on properly. No
if's, but's or maybe's!

You need to follow all of the steps of the Access Security FAQ *precisely* -
no additioons, deletions or alterations.

HTH,
TC

 

[Daniel]

I resolved the problem by doing the following...

I ran the 'User level security wizard' and pointed access to the Workgroup
file I had already setup. The wizard has now bind my database to the
workgroup properly and can't be accessed without it. Yah!