Splitting database with password

microsoft.public.access.security

10 Aug 2006 8:13 PM

Bernard

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?

--
Bernard
--
Bernard

11 Aug 2006 4:41 PM

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.