Remote Access database connection

[jggtz]

Actually I have a SQL Server in a remote pc with a public IP and can connect with no problems over the internet using ADO, just by giving the IP instead of the server name in the connection string ...
Now I need to connect with an Access database in the same remote pc..
Any help will be appreciated... Thanks

[TrevorG]

I'm prepared to be shot down in flames but I believe that Access is a file based RDBMS (whereas SQL Server is network based) so to connect to it over a network you must have permission to access the server/folder containing the database.

Assuming you have access to the relevant folder you can use ADO to connect by using a connection string in the format of:

CnxString = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
              "Persist Security Info=False;" & _
              "Data Source=" & strDbPath & _
              ";Mode=Read"

Where strDbPath is like "F:\MyDbFolder\MyData.Mdb" [using mapped drive F:] or "\\NetwokServer\SharedFolder\MyData.Mdb"
Edit this to your particular requirements.

Trevor