请各位前辈帮我解决，远程连接网上空间的ACCESS2000数据库！！急！！！！

Question

抄自
http://www.able-consulting.com/ADO_Conn.htm#RemoteOLEDBProviderConnectionsIf MDB is located on a Network Share:oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
           "Dbq=\\myServer\myShare\myPath\myDb.mdb;" & _
           "Uid=admin;" & _
           "Pwd=;"
MS Remote - Access (Jet) 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=c:\somepath\mydb.mdb;", _
            "admin", ""
If you want to use an OLE DB Provider on the remote machine (via RDS DataFactory
Default Handler):oConn.Open "Provider=MS Remote;" & _ 
           "Remote Server=http://myServerName;" & _
           "Handler=MSDFMAP.Handler;" & _
           "Data Source=MyAdvworksConn;"
The corresponding entry in the \winnt\Msdfmap.ini file would be:[connect MyAdvworksConn]
Access = ReadWrite
Connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mydb.mdb;User Id=admin;Password=;"
 

Answer 1

我有办法了。
[email protected]