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/comm...f-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

"Question Boy" <(E-Mail Removed)> wrote in message news:9D7CD3D0-60C9-4829-8F20-(E-Mail Removed)...
>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/comm...f-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.

--
Joan Wild
Microsoft Access MVP