???VB 5 CODE OPEN ACCESS DATABASE????
Try,
Dim db As Database
set db = OpenDatabase(App.Path & "\dbname.mdb", False, False, ";PWD=
password")
Dont forget the semicolon!
etta
Quote:
>How do I open a secured database from vb5 that also has a database
password.
>I open it like this:
>dbUser = "mike"
>dbUserPassword = "123"
>DatabasePassword = "xxx"
>DBEngine.SystemDB = "SB.mdw"
>DBEngine.DefaultUser = dbUser
>DBEngine.DefaultPassword = dbUserPassword
>DBEngine.DefaultType = dbUseJet
>Set dbWS = DBEngine.CreateWorkspace("", dbUser, dbUserPassword)
>Set db = OpenDatabase(gMainDBPathAndName)
>But if I assign a database password in access to the database then I have
no
>idea where to place the password or what syntax to use...
>Thanks
