Setting Security and splitting a dbase

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Before I start securing my database do I need to split it
into a FE and BE or can I split it after I finish securing
it?
 
If you secure first and then use the database splitter, you'll end up with a
secure frontend, but unsecure backend. So you end up having to resecure the
backend. The solution to this is 'don't use the splitter wizard'. It's
easy enough to split manually and keep your permissions intact.

I would secure it and then split. To split manually:

Copy your database. Open the copy and delete all objects except the tables.
Open your original and delete all the tables/relationships. Go to File, Get
External Data, Link Tables and navigate to your copy and select all the
tables.
That's it. If you move the backend, you can use the Linked Table Manager to
refresh the links.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

splitting a secured dbase in access 2003 3
Securing a split database 1
Split DB security 1
Secure Database Before or After Split? 1
Setup data security in Access 2003 3
Security and .mdE 3
Mobile phone texts split into incoming and outgoing messages 0
FE and BE security 7

Back
Top