How to pass a PASSWORD to the back end db

[Cleis]

Group:

I have an A/R database that has a front end (5) users and one back end on a local server. I have created MDE's and placed one on each users machine. I have disabled the f11 key and prevented my users from gaining access to the Access container on their desktops. One additional point of interest, The front end databases are linked to the the backend via the linked table manager.

What I want to do is is put a password on the backend database (where the data is stored)but to do this, I need to pass the "password" for the back end when the front ends are opened.

I've looked for code help on this forum to no avail.

Does anyone have a suggestion. No I don't want to mess with teh MDW file if I don't have too.


Thanks in advance!


Itch

 

[Remou]

You can relink your tables choosing to save the password when you do. You may also need a little code to add missing linked tables, for example:

strConnect = "MS Access;PWD=Password;DATABASE=" & Me.txtNewDataDirectory

db.TableDefs("tablename").Connect = strConnect