DAO password protected Access database

[dammansky]

Hi,

how can i connect to an Access database that has a password on it

When i use opendatabase("<Mypath>",,,"pwd=<MyPassword>") it says that my password is incorrect (and i'm sure it is not.

PS i know how to do this with ado, but it is a program that is already written and now we have to change it so the database has a password on it.

Thanx

[rajnirmala]

Tell me the code. I would like to know whether u want to do this in VB/ASP

[Cubbie]

Here is some old DAO code I came across. Try it out.

Dim ws as Workspace
Dim db as Database
' Open workspace, database, recordset
set ws = DBEngine.Workspaces(0)
' Password protected
set db = ws.OpenDatabase("DatabasePath", false, false, "MS Access;pwd=password")