Not a valid path

[samotek]

In my command to open the database in another computer called Valja I get a run time error runtime error 3404 \\Valja\BE\be.mdb is not a valid path
It happens when when I try to open it by the command :
Set db = DBEngine.Workspaces(0).OpenDatabase(VaPath, dbDriverComplete, False, "; PWD=" & strPassword)
I get the path through the following constant :
Public Const VaPath As String = \\Valja\BE\be.mdb
It is surprising because my Shell command with the same path works without ptoblems :
Shell """C:\Program Files\WinZip\WZzip.exe"" \\Valia\BE\ArchiveBE\BE" & Format(Date, "yyyymmdd") & " C:\BE\BE.mdb"
Could you help me find the reason ?

 

[PHV]

Public Const VaPath As String = [!]"[/!]\\Valja\BE\be.mdb[!]"[/!]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ZmrAbdulla]

or[tt]
Public VaPath As String
VaPath = "\\Valja\BE\be.mdb"
[/tt]

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[JerryKlmns]

\\Valia\BE\ArchiveBE\BE" & Format(Date, "yyyymmdd") & " C:\BE\BE.mdb"

"\\Valja\BE\be.mdb"

Don't seem equal to me. Your shell command uses winzip or am I reading wrong??

 

[ZmrAbdulla]

Jerry, did you mean the spelling difference?

"[COLOR=red yellow] [/color]\\Valia\BE\ArchiveBE\BE" & Format(Date, "yyyymmdd") & "[COLOR=red yellow] [/color]C:\BE\BE.mdb"

"\\Val[COLOR=red white]j[/color]a\BE\be.mdb"


________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[JerryKlmns]

Zameer,

Spelling is one thing. The other is whether samotek is trying to open a zipped db!