Linked table passwords

[Phil at Probills]

I run a system that uses a front end database with all the code etc, and a
number of databases, one for each client. Using code in a form on the main
DB I access tables in a clients database using a code string e.g:

DoCmd.TransferDatabase acLink, "Microsoft Access", "\\phil\phil
(C)\pbadata\" & [newclient] & ".mdb", acTable, "Main", "Main", False

A similar string is used to link 3 key tables in the client db. Each time
I change clients, the links to the outgoing client tables are removed and
then the code establishes the link to the tables in the new client db. I
would like to protect each client db with a password but if I do this I have
to key in the password each time the code establishes a link to the new
tables. Is there any way I can alter the code string so that the password
is automatically entered by the system, not my keyboard?

I use a code based password string to automate the compaction of the primary
database, but can't seem to achieve the same result with this string. Any
help would be appreciated.

 

[Sue Mosher [MVP-Outlook]]

Perhaps you meant to post this in an Access forum, rather than an Outlook group?

 

[Phil at Probills]

Thanks Sue,

I'm new to this - the group I selected was titled "Programming VBA" so I
thought that wssd appropriate - I have since moved the post to an Access group
--
Phil W

Perhaps you meant to post this in an Access forum, rather than an Outlook group?
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

I run a system that uses a front end database with all the code etc, and a
number of databases, one for each client. Using code in a form on the main
DB I access tables in a clients database using a code string e.g:

DoCmd.TransferDatabase acLink, "Microsoft Access", "\\phil\phil
(C)\pbadata\" & [newclient] & ".mdb", acTable, "Main", "Main", False

A similar string is used to link 3 key tables in the client db. Each time
I change clients, the links to the outgoing client tables are removed and
then the code establishes the link to the tables in the new client db. I
would like to protect each client db with a password but if I do this I have
to key in the password each time the code establishes a link to the new
tables. Is there any way I can alter the code string so that the password
is automatically entered by the system, not my keyboard?

I use a code based password string to automate the compaction of the primary
database, but can't seem to achieve the same result with this string. Any
help would be appreciated.

 

[Sue Mosher [MVP-Outlook]]

Might want to check the full name next time. The full name of this newsgroup is microsoft.public.outlook.program_vba.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

Thanks Sue,

I'm new to this - the group I selected was titled "Programming VBA" so I
thought that wssd appropriate - I have since moved the post to an Access group
--
Phil W

Perhaps you meant to post this in an Access forum, rather than an Outlook group?

I run a system that uses a front end database with all the code etc, and a
number of databases, one for each client. Using code in a form on the main
DB I access tables in a clients database using a code string e.g:

DoCmd.TransferDatabase acLink, "Microsoft Access", "\\phil\phil
(C)\pbadata\" & [newclient] & ".mdb", acTable, "Main", "Main", False

A similar string is used to link 3 key tables in the client db. Each time
I change clients, the links to the outgoing client tables are removed and
then the code establishes the link to the tables in the new client db. I
would like to protect each client db with a password but if I do this I have
to key in the password each time the code establishes a link to the new
tables. Is there any way I can alter the code string so that the password
is automatically entered by the system, not my keyboard?

I use a code based password string to automate the compaction of the primary
database, but can't seem to achieve the same result with this string. Any
help would be appreciated.