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

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. :bigyello:

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

thanks pasvorto... :thumb: