Ok say you create a db like this:
Set dbsData = CreateDatabase("C:\NewDB.mdb", dbLangGeneral & ";pwd=password")
ok so now you want to open it like this
Set dbsData = OpenDatabase("C:\NewDB1.mdb")
but then you get a message and error saying invalid password so I looked in then help and it says this
Set database = workspace.OpenDatabase (dbname, options, read-only, connect)

and it says for the connect Optional. A Variant (String subtype) that specifies various connection information, including passwords. I have tried and tried so many different ways to put the password in there and nothing works. so how do you open it?
Thanks!!