Using access with a password.... nid help?

[Mark_V]

hi pipz,

just a simple question. how do u connect vb to a access db that has a password?

i created a db first without a password and using vb , it works. but wen i activated the security for my db. it gives me an error. could u show me how to connect my vb with access?

Thanks in advance.

[Pasvorto]

strcnxn = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDBatabase Password =fred;Data Source=C:\Techni.mdb;Jet OLEDB:Engine Type=4;"
Cnxn.Open strcnxn

[Mark_V]

thanks pasvorto...