Splitting database with password

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top