P
Phil at Probills
I run a database system that uses a front end database that is set up to link
to a number of data databases using the following code
DoCmd.TransferDatabase acLink, "Microsoft Access", "\\phil\phil
(C)\pbadata\" & [newclient] & ".mdb", acTable, "Main", "Main", False
I have a separate database for each client. The above code establishes a
link with key tables in each client database.
I would like to secure each client database with a password so they cannot
be accessed directly unless the password is used. The problem with this is
that when I switch from one client to the next using a form with the code
shown above I am prompted for the paswword for each link trnasaction - this
is very time consuming and annoying.
I have tried adding code e.g pwd = **** to various places in the code but
nothing seems to work.
Is it possible to add the password to the code string or not??
Any help would be greatly appreciated.
to a number of data databases using the following code
DoCmd.TransferDatabase acLink, "Microsoft Access", "\\phil\phil
(C)\pbadata\" & [newclient] & ".mdb", acTable, "Main", "Main", False
I have a separate database for each client. The above code establishes a
link with key tables in each client database.
I would like to secure each client database with a password so they cannot
be accessed directly unless the password is used. The problem with this is
that when I switch from one client to the next using a form with the code
shown above I am prompted for the paswword for each link trnasaction - this
is very time consuming and annoying.
I have tried adding code e.g pwd = **** to various places in the code but
nothing seems to work.
Is it possible to add the password to the code string or not??
Any help would be greatly appreciated.