48Highlander
Technical User
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
[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