Hi, Is it possible to create an mdb database with password protection in EB. Thanks
I'm almost positive that it is possible but I just don't know the specific string.
Larry
I am after this too... there must be a way for sure.
I have Access on my machine, so setting the password is easy. This works to open a password protected database where the password is "test":
OPENCONSOLE
Def pdb as pointer
pdb = dbConnect("Microsoft Access Driver (*.mdb)",GETSTARTPATH + "db1.mdb","PWD=test")
if (pdb = null)
print "Connection failed"
ELSE
PRINT "Connection successful"
DBDISCONNECT(pdb)
ENDIF
DO:UNTIL INKEY$ <> ""
CLOSECONSOLE
END
Hmm... was so easy, afterall. I mean, after reading this, I checked EB help, and in dbconnect help, the example shows exactly how to do it. Thanks, Peaslee. At least I have not paied much attention to help files, once again.
The part I can't get is how to set the password when you create the db file in code. I use Access for most database applications because it makes it easy to create the file with sample data.