DataBase Security

  • Thread starter Thread starter Michael Jacob
  • Start date Start date
M

Michael Jacob

My database is secured with a password, and it only opens
with that password.
The problem is when I try to open the Database from
Visual Basic, using the OpenDatabase method. How do i
pass the password.
This is not the User Level Security.
It sounds very simple, but I have not found any
documentation on this.
 
My database is secured with a password, and it only opens
with that password.
The problem is when I try to open the Database from
Visual Basic, using the OpenDatabase method. How do i
pass the password.
This is not the User Level Security.
It sounds very simple, but I have not found any
documentation on this.
Click to expand...

You must use the connect parameter of the OpenDatabase method.

'***EXAMPLE START
Dim db As DAO.Database

Set db = DBEngine.OpenDatabase("c:\MyData\MyData.mdb", _
False, False, ";pwd=password")

'***EXAMPLE END
 
Bruce, That worked perfect. Thanks

-----Original Message-----

You must use the connect parameter of the OpenDatabase method.

'***EXAMPLE START
Dim db As DAO.Database

Set db = DBEngine.OpenDatabase ("c:\MyData\MyData.mdb", _
False, False, ";pwd=password")

'***EXAMPLE END

--
Bruce M. Thompson, Microsoft Access MVP
(e-mail address removed) (See the Access FAQ at http://www.mvps.org/access)
within the newsgroups so that all might benefit.<<



.
Click to expand...
 
Back
Top