Can anyone tell me why this code is not working I have the
correct information need to support opening the access
database, but this one line keeps failing.

I have never used the Exclusive or the Password part of
this code. How can I do this correctly.

Thank You

dba.OpenCurrentDatabase filepath:=stgPath,[Exclusive =
false], bstrPassword = test

unless test is a variable that contains the string value
of the password, test shuld be "test"

dba.OpenCurrentDatabase filepath:=stgPath,[Exclusive =
false], bstrPassword = "test"


cheers
Juan


-----Original Message-----
Can anyone tell me why this code is not working I have
the
correct information need to support opening the access
database, but this one line keeps failing.

I have never used the Exclusive or the Password part of
this code. How can I do this correctly.

Thank You

dba.OpenCurrentDatabase filepath:=stgPath,[Exclusive =
false], bstrPassword = test
.

wrote ...

dba.OpenCurrentDatabase filepath:=stgPath,[Exclusive =
false], bstrPassword = test

Just a guess but you may want:

dba.OpenCurrentDatabase _
filepath:=stgPath, _
Exclusive:= False, _
bstrPassword:= "test"

Or briefer:

dba.OpenCurrentDatabase stgPath, False, "test"

If test is a variable, omit the quotes.

Jamie.

--