Securing front end and back end with same mdw file 1

[48Highlander]

I have been working away on my application and I have inplemented user level security. I implemented this after I had split the application into front and back ends. I am getting increasingly concerned about security and so I thought that I would check and see if I could access the back end after I started Access and joined the system.mdw workgroup. I can!

How do I get the back end to require the same workgroup file as the front end?


Bill J

 

[Ed2020]

A quick and easy way is to cheat:

1. Take a copy of your frontend database.

2. Delete all the objects and remove the VBA project password, of you have one.

3. Import all the objects from your current unsecured backend into the MDB you have just emptied.

4. Relink all your tabes accordingly.

Note that this will only work correcyly if you have set your permissions on new table objects correctly.

HTH,

Ed Metcalfe.

Please do not feed the trolls.....