access with password protection

[nutstretch]

Can I put a password onto a database and still be able to call it through VB6

Heres hoping

nuts

[Dr_Evil]

If you are using ADO this allows you to open a password protected database.

Dim cn as ADODB.Connection
Set cn = New ADODB.Connectioncn.Provider = "Microsoft.Jet.OLEDB.3.51"

cn.ConnectionString = "Data Source=D:\db1.mdb;Jet OLEDB :database password=your_password"
cn.CursorLocation = adUseClient
cn.Open

[nutstretch]

thanks i'll try that
nuts