access password

[hcleo]

if my access database has been protected by a password, how i'm login form vb coding?

[pardede]

check this link http://vbcode.webhostme.com/en/click.asp?id=51

[Chris]

Here is for ADO method:

Dim Conn as New ADODB.Connection
Dim MyPwd$

MyPwd$ = "123456789"

With Conn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=C:\MyDb.mdb; Jet OLEDB atabase Password= " & MyPwd$
.Mode = adModeReadWrite
.Open
End With

------------------
A free Man stand on a free Land.
[email protected]

[This message has been edited by Chris (edited 02-21-2000).]