Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add password to back end mdb

Status
Not open for further replies.

48Highlander

Technical User
Feb 8, 2004
119
CA
Using ACC 2003. I have an application being used by several clients and I need to password protect the back end mdb database. Currently using Access security with .mdw file and there is NO pwd on the back end. I have thought of two approaches:
[ol 1]
[li]Based on a change in the build number, have my application add a password to the back end. I can't get this to work because I get an error saying that my app needs exclusive access to the back end to make the change. I have tried VBA to close the currentdb, reopen it in exclusive mode and then set the pwd but I still get an error[/li]
[li]Distributing to my clients a mde file that will change the password on their back end data. The problem with this is that I can't find a way to ensure that the back end database pwd has been set. (My app opens / relinks the back end with a pwd in the connection string but if there is no pwd in the back end it still opens!)[/li]
[/ol]

Anybody have an idea that will help?

Bill J
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top