I am creating a VB6 application that will be distributed with an Access97 mdb. The database will not be written to in any way, simply looked at with a number of "Select" queries. I need to be able to prevent the mdb from being accessed outside of my program. If I password protect the mdb, can I somehow insert the password into the VB code, without any action on the part of the user? Preferably, the user wouldn't even be aware of the need for a password. <br>The idea is to limit the mdb access to a particular program (mine), not to a particular user. Any help would be greatly appreciated.
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VB6/MS Access/Password
- Thread starter JTA
- Start date
- Thread starter
- #3
Any idea how/where I would go about inserting the VB code?<br>At the present I am only "looking at" the data via a<br>'Data1.RecordSource = "Select * From....etc."<br><br>When I set a password for access, then run the program, the program halts with a msgbox reading "Not a valid password" right after running the query. This is with no password coding whatsoever. There's gotta be an easy way to do it, I'm certainly not the only one to have this requirement, but damned if I can find reference to it anywhere. Any ideas?<br><br>Thanks.
For an extensive tutorial How to do this and much more with databases. I usually go to <A HREF=" TARGET="_new"> tutorial #6 encompasses the question which you are asking.<br><br> John Stephens
Private Sub Command1_Click()<br>Dim Db AS Dao.Database<br>Dim Password As String<br>Dim DbPath As string<br><br>Password="1111"<br>DbPath="c:\Temp\Db1.mdb"<br>Set Db=OpenDataBase(DbPath,True,False,";pwd=" & Password) <br>
- Status
