Results 1 to 4 of 4
  1. #1
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568

    ODBC with remote path to server

    Hi Guys,

    I am on virtual machine with windows and trying to connect to FE from user account:

    Code:
     Sub Test()
    
    
        Dim conn
    
    
            Set conn = CreateObject("ADODB.Connection")
            
            glbConnString = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=\\192.168.170.33\C:\Access FE\Model Excel-Database.accdb;"
            
            conn.Open glbConnString
    
    
    End Sub
    Without IP this is working fine.
    But i want to connect to this VM outside from it using ODBC connection.
    How to do it properly?

    I think that UNC path should work also something like
    \\localhost\C:\Access FE\Model Excel-Database.accdb; but it doesnt.

    And here i am seeing that it is possible to do it:
    https://social.msdn.microsoft.com/Fo...orum=vbgeneral



    Please help,
    Best,
    Jacek

  2. #2
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Ok when i get full UNC path this is working:

    Code:
    \\devwin2012-197-\Access FE\Model Excel-Database.accdb
    and i think this should work also using IP address.
    Why this is not working?

    Best,
    Jacek

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I've never tried using IP address and a VM to connect but for UNC paths you omit the : after the drive letter C
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    ok thank you Ridders.

    it is working, my path was with errors.

    Best,
    Jacek

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Connection lost from mysql remote odbc with MS Access
    By zeeshanaslamdurrani in forum Code Repository
    Replies: 1
    Last Post: 02-21-2016, 07:13 AM
  2. Path to ODBC Driver
    By cbouley in forum Access
    Replies: 3
    Last Post: 04-23-2013, 10:00 AM
  3. Replies: 3
    Last Post: 02-23-2012, 07:16 PM
  4. Table fetching remote server
    By Manotosh in forum Access
    Replies: 2
    Last Post: 10-26-2011, 09:38 AM
  5. Getting date/time from remote server
    By mxfrail in forum Programming
    Replies: 4
    Last Post: 09-21-2009, 07:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums