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

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

Guest

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?
 
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
 
Back
Top