Passing a database password from a front end app to the back end

[Kent]

I have a front end app written in MS Access 2003 which links to back end data
tables in another db. I use modules to perform the linking which is
controlled via the front end.
I need to secure the back end and don't wish to use an mdw.
I have set a back end db password and wish to pass the password fron the
front end to the back end.
Has anyone got any code for this?

 

[tina]

one way to do this uses the following syntax to include the correct password
to the backend, when you create the link:

ConnectOutput(CurrentDb, strTbl, _
";DATABASE=" & strF & ";PWD=" & strP, strTbl)

strTbl is a variable for the table name, strF is a variable for the
filepath, and strP is a variable for the backend password. all three
variables are String data type. i use this code in an A2000 db running
A2003, so it should run in your db too, AFAIK.

hth