Theoretically, you can do that. The MS Remote provider uses the RDS DataFactory on the remote server. Hence you must have RDS setup and configured correctly on the remote server.If you want to use an ODBC DSN on the remote machine:oConn.Open "Provider=MS Remote;" & _ "Remote Server=http://myServerName;" & _ "Remote Provider=MSDASQL;" & _ "DSN=AdvWorks;" & _ "Uid=myUsername;" & _ "Pwd=myPassword;" If you want to use an OLE DB Provider on the remote machine:oConn.Open "Provider=MS Remote;" & _ "Remote Server=http://myServerName;" & _ "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=\somepath\mydb.mdb;", _ "admin", "" this article provides step by step procedures on how to connect to a remote access database:http://www.msdn.microsoft.com/library/default.asp?URL=/library/en-us/dn_voices_webmen/html/webmen100598.asp
数据库不大的话,可以先下载,再显示。
自动下载不难做,用Inet控件,几句话就可以实现。
不可以!!!
>>如果用ODBC,可以直接在ODBC里创建映射。
不可以!!!
"Remote Server=http://myServerName;" & _
"Remote Provider=MSDASQL;" & _
"DSN=AdvWorks;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;" If you want to use an OLE DB Provider on the remote machine:oConn.Open "Provider=MS Remote;" & _
"Remote Server=http://myServerName;" & _
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\somepath\mydb.mdb;", _
"admin", ""
this article provides step by step procedures on how to connect to a remote access database:http://www.msdn.microsoft.com/library/default.asp?URL=/library/en-us/dn_voices_webmen/html/webmen100598.asp