Linked table passwords

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Perhaps you meant to post this in an Access forum, rather than an Outlook group?
 
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


Sue Mosher said:
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

Phil at Probills said:
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.
Click to expand...
Click to expand...
 
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


Phil at Probills said:
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


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

Phil at Probills said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top