Database with password protect

[Pip1957]

Hi, Is it possible to create an mdb database with password protection in EB. Thanks

[LarryMc]

I'm almost positive that it is possible but I just don't know the specific string.

Larry

[JoaoAfonso]

I am after this too... there must be a way for sure.

[Bruce Peaslee]

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":

Code Select Expand


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



[JoaoAfonso]

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.

[Bruce Peaslee]

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.