Results 1 to 2 of 2

Thread: path not valid

  1. #1
    Join Date
    Mar 2006
    Posts
    42

    Unanswered: path not valid

    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 ?

  2. #2
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    Does your expression really not have the quotes, or is that a error in posting?

    Public Const VaPath As String = \\Valja\BE\be.mdb

    versus

    Public Const VaPath As String = "\\Valja\BE\be.mdb"

    tc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •