I have two databases (dtdata which is linked to dt). I set a password in dtdata by opening it in elxcusive mode, then choosing Tools, Security, and Set DB password.
I would like to be able to open the main file (dt) and pass the password to
dtdata in VBA which is needed before it can open.
In my main file, I have used the statement Set DB=Currentdb().
I would like to be able to open the main file (dt) and pass the password to
dtdata in VBA which is needed before it can open.
In my main file, I have used the statement Set DB=Currentdb().