Access Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You can include the password in the open:

strDestinationMDB = "\\jo\SharedDocs\Access\ciscms.mdb"
Set dbf = DBEngine.OpenDatabase(strDestinationMDB, _
False, False, ";pwd=Frrito")
 
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.
 
Back
Top