Password protection on split database

T

Tony Williams

I have a database which is split into front end and back end. The front end
is password protected but the backend isn't Is it possible to protect both
with the same password? I've tried protecting the backend with a password
but when I open the front end it can't "see" the backend.
Any ideas?
Thanks
Tony
 
G

George Nicholson

Put a password on the backend, then, after opening the front-end, use the
Linked Table Manager to update the links (just like you would if you had
moved the backend). You should be prompted for the 'missing' password during
this process.

You should only need to do this once, as the password (once supplied) will
be remembered from session to session.
 
T

Tony Williams

Thanks George
Tony
George Nicholson said:
Put a password on the backend, then, after opening the front-end, use the
Linked Table Manager to update the links (just like you would if you had
moved the backend). You should be prompted for the 'missing' password
during this process.

You should only need to do this once, as the password (once supplied) will
be remembered from session to session.
 
T

Tony Williams

George tried your solution but when I use the Linked Table Manager to update
the links I get a message that says Not a valid password but no option to
input one?
Any suggestions?
Tony
 
R

Rick Brandt

Tony said:
George tried your solution but when I use the Linked Table Manager to
update the links I get a message that says Not a valid password but
no option to input one?
Any suggestions?

You might have to delete the links and re-create them from scratch.
 

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

Un-split database 9
Split Table 1
backend compacting 1
Passwords 4
Split database - how to run VBA stored in the backend? 2
Separating the database 8
Splitting A Database 3
General Network Question 5

Top