Im using the Opendatabase method in excel VBA and i'm running into problems. Here is my connection string
dim dbs as Database
dim rs as recordset
set dbs = opendatabase("c:\sun.mdb", , ,"PWD=tester")
When it reaches the opendatabase line, it gives me an error..."INVALID PASSWORD" when the password is right? If i disable the password it works? Any ideas?