A split database

[Guest]

I have split my database and would now like to protect
the back end (BE) structure with a password. I don't need
to have the user use a password to run the program. When
ever I add a password to the (be) database I have to use
a password inorder to use the program. Is there any way
to just protect the database??

Thanks for your help

 

[JohnR]

Delete all the links to the BE from the FE. Relink the
tables and look for a button marked "Save Password" during
the process. This will add the password to the connection
string and the users will not be asked for it.

Or Open your linked table in design view. Click on the
properties button and insert the password in the
connection string between the double quotes in PWD=""