Access Table

K

kiran

Hi All,
I have set the password to my access db when i try to open from Visual Basic
gives an error not a valid password how do i solve this.

TIA
 
K

Klatuu

You can include the password in the open:

strDestinationMDB = "\\jo\SharedDocs\Access\ciscms.mdb"
Set dbf = DBEngine.OpenDatabase(strDestinationMDB, _
False, False, ";pwd=Frrito")
 
D

Douglas J. Steele

Just a reminder that while the 2nd and 3rd arguments are optional, you must
include them in the OpenDatabase call or it won't recognize the 4th
paramter.
 
Top