VB DAO ACCESS MDB Password protection - TechRepublic
General discussion
August 3, 2001 at 03:41 AM
absub1

VB DAO ACCESS MDB Password protection

by absub1 . Updated 24 years, 10 months ago

I have written a program in Visual Basic.
The program uses DAO 3.51
Back end is a MS-Access mdb file

Now I want to add password protection.
I have set up password for the mdb.

I am using the
Set ws = DBEngine.CreateWorkspace(“Temp”, “admin”, “”)

Set db = ws.OpenDatabase(“c:\mydata.mdb”)

the using a recordset object.

Now where and how does the password fit in?

If you could give me working code, I will be very happy.

Thank you

This discussion is locked

All Comments