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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to split Front end/Back end 7
back-end security 3
Securing the back-end 1
Minimum Level of Security for the Back End 3
back end security 5
Back up front end database with security 2
Front End database 18
Securing Back End Only 2

Back
Top