Securing the back-end

[Question Boy]

I had a split db. Then I ran the security wizard on the front-end. That
worked fine. Now however, I am lost at securing the back-end. I tried
aimply adding a password, then the linked tables don't work. I tried
following the post
http://www.microsoft.com/office/com...&p=1&tid=0eca369c-fb6f-4f86-991f-45c2eece71fc
but can't seem to get it to work either. It ran, but it is still unsecured
and I tried rrerunning the wizard and it give me an error... that it cannot
be rerun as it has already been run. I only want to link the back-end to the
same security file as the front-end. How can I do this?

QB

 

[Joan Wild]

I had a split db. Then I ran the security wizard on the front-end. That
worked fine. Now however, I am lost at securing the back-end. I tried
aimply adding a password, then the linked tables don't work. I tried
following the post
http://www.microsoft.com/office/com...&p=1&tid=0eca369c-fb6f-4f86-991f-45c2eece71fc
but can't seem to get it to work either. It ran, but it is still unsecured
and I tried rrerunning the wizard and it give me an error... that it cannot
be rerun as it has already been run. I only want to link the back-end to the
same security file as the front-end. How can I do this?

QB

You can open the frontend via the shortcut you have now, and log in as a user you want to secure the BE with. That will start a session of Access using the correct mdw file. Then secure the BE.

Create a new mdb
Import all the objects from the backend.
Go to Tools, security, permissions and remove all permissions for every object from the Users Group
Assign whatever permissions you need to the groups you have created. If you've used RWOP queries in the frontend, then your groups will only need Open Permission on the Database object and no permissions on the tables.