Hello,

I am using the Visual Sudio 2005 / C#.
I have no prroblem to connect to a local MS-Access database.

I would like to connect to a remote MS-Access
What software should run on the machine that hold the MS-Access?

Let say the the MS-Access name is AccessTest.mdb, the table name testtable, and it's located in C:\testdirectory
How can I access this table?

 Thanks,

Aaron

my way may not 100% correct, but it works

you can mapping that remote IP in one of drive letter let say

mapping \\xxx.xxx.xxx.xx\C:\testdirectory to S:

then you can just use S:\xxx.mdb in your connection string

The problem is, to connect to a remote MS-Access Over the Internet.

when Itried to map the drive according to the above answer I got an error message
"The drive could not be mapped because no network was found"

Is there any other details that should be taka in account when mapping the drive like
User, password, port and so on?

Hi adembitz,

We cannot connect to a remote MS-Access database file over the Internet. Because it is a file based database system, and file share across the internet is not allowed.

In this case, I suggest you try to move to SQL Server. In SQL Server, you can specify the IP address and port as datasource using TCP/IP. This can be done directly in the connection string.

Here is a sample connection string:

Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

please note; DBMSSOCN=TCP/IP. This is how to use TCP/IP instead of Named Pipes. At the end of the Data Source is the port to use. 1433 is the default port for SQL Server. 

HTH. If anything is unclear, please feel free to mark the post as Not Answered and post your reply. Thanks!