Conecting/Linked External Table over the Network

[Yance]

Hello, i try to make connection or make a link to the external table in other computer (on a network) without share the folder/drive where the table is. Is there anyone here know how to do this in programmatically?


Any help greatly appreciated!

Regards,

Yance

[NoellaG]

Hi,

to make a remote connection to another Access data file:

dim cnnRemote As New ADODB.Connection

cnnRemote.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strFile
cnnRemote.Open


Microsoft.ACE.OLEDB.12.0 is for Access 2007, for Access 2003 this will probably be 10.0, but I'm not sure, and strFile = name and path of the access file.
Of course, you must have access rights to the file you want to connect to.

Success
NG

[Yance]

Hi,

to make a remote connection to another Access data file:

dim cnnRemote As New ADODB.Connection

cnnRemote.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strFile
cnnRemote.Open


Microsoft.ACE.OLEDB.12.0 is for Access 2007, for Access 2003 this will probably be 10.0, but I'm not sure, and strFile = name and path of the access file.
Of course, you must have access rights to the file you want to connect to.

Success
NG

Thanks for your replay. But my question is how we can connect the table without share the folder/drive where the table is? Is it possible?

[NoellaG]

Hi;

you always need a kind of access to the database you want to connect to, but maybe working with sharepoint tables is an option for you?

gr
NG

[Yance]

Never use sharepoint table. Can you give any reference for this?

[Yance]

I have find on this http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx. It seems i must use Windows Server