Splitting database with password

G

Guest

I wish to split my Access database 2003 which has 25 tables. I used the
splitting wizard but the backend database then has no password. When I add a
'be' password the 'fe' cannot access the 'be' because of the new password. I
can't find an easy way of putting the password into all the linked tables so
that the 'fe' can access them. I could delete the links and then relink all
the tables indivdually when the 'be' password can be added. Is this the only
way?
 
T

t568aort568b

Yes, you must put the password on the be. Delete all the table links
in the fe. When you goto relink them it will ask for the passord.
After that the fe will remember the password until it is changed.
 

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

Microsoft Access Table Security 2
encryption with Access on a laptop 5
FE/BE Password Help 1
Problems with splitting a database 4
splitting a secured dbase in access 2003 3
Backend DB Password 2
Securing Back-End, Using one .mdw file on FE & BE 3
Add password to backend 1

Top