Send Access 97 Password (VB5)

[SLS]

I have tried all the suggestions I have seen so far, I keep getting Invalid Password.
or
Could not find installed ISAM Files

I am Not using ODBC

Can anybody please give me the Simple OpenDatabase string for a simple Access 97 Password Protected Database.

Before protection I used the following Code....

DataBaseName1 = "ShawVideo(Terminal).mdb"
Set DataBase1 = Workspaces(0).OpenDatabase(DataBaseName1)

I have protected the Access Database just using a password to prevent users changing data.

I know it is something like...
Set DataBase1 = Workspaces(0).OpenDatabase(DataBaseName1,False,False,"psw=password&quot

But No Luck

Thanks

 

[CajunCenturion]

you're quite close

Set DataBase1 = Workspaces(0).OpenDatabase(DataBaseName1,False,False,";pwd=password&quot

add the semi-colon and use pwd not psw Good Luck
------------
Select * from Users where Clue > 0
0 rows returned

 

[SLS]

Thanks.....
Works fine now

It had to be someting simple

 

[MycroftHolmes]

Set DataBase1 = Workspaces(0).OpenDatabase(DataBaseName1,False,False,";pwd=password&quot

And as I just finally firgured out, there can be no spaces after the pwd= or the password is sent with a leading space.