pafcpilgrim
Keeping it Green
- Local time
- Today, 09:43
- Joined
- Apr 14, 2005
- Messages
- 36
Guys i have created and automatic table linking system so if a user moves their data file (BE) or it for what ever reason the database file cannot read the linked tables it will prompt the user to select the new location and re-establish all the links to the tables in that data file.
What i want to do though, is set the basic access password on the BE so there is at least some form of protection, the problem i am getting is getting it to pick up the password in the following code
this doesn't work can someone point me in the right direction please. thanks.
What i want to do though, is set the basic access password on the BE so there is at least some form of protection, the problem i am getting is getting it to pick up the password in the following code
Code:
Set dbsAPData = wrkJet.OpenDatabase(strDataFilePath, , True, ";PWD=APDB1001")this doesn't work can someone point me in the right direction please. thanks.
