Front End Back End Security

[Paul Ilacqua]

I'm going to split my secured database. Will I need to re-apply security
after the split?
Do I need to apply permissions to the Back end Tables and front end (newly
linked tables)
Thanks

Paul

 

[Joan Wild]

I would split it manually. If you use the database splitter wizard, the
resulting backend will be totally unsecured and you'll have to redo.

To split manually.
Copy your database. Open the copy and delete all queries, forms, reports,
modules. This will be the backend.

Open the original database and delete all tables/relationships. Use File,
Get External Data, Link Tables to navigate to the location of the backend;
select all the tables and Link.

The only thing left to do is give full permissions on the tables links in
the frontend. The users will still be restricted by the permissions you've
placed on the tables in the backend.