Connect via ODBC to Access FE on remote server from Excel

[jaryszek]

Hi,

i am connecting to windows server 2012 using VPN and Remote Desktop Panel.

And there is my Access where i want to connect to.

Code:


Sub Test

Dim conn




Set conn = CreateObject("ADODB.Connection")

glbConnString = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=\\192.168.170.22\C:\Access FE\Model Excel-Database.accdb;"

conn.Open glbConnString


End sub

It is possible?

Best,
Jacek