Hi Guys,
I am on virtual machine with windows and trying to connect to FE from user account:
Without IP this is working fine.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
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