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

[zjgj]

请问各位前辈，我是个菜鸟，对VB了解不是很深，我想做一个本地维护网上的程序，所以就得先连接网上那个数据库，而网上的空间只支持ACCESS2000，我不知道用什么方法去连接它，有没有办法？我很急的，谢谢各位前辈！！！！！！！

[superauu]

连不了，你分多都给我把，嘿嘿

[jdsbjcailei]

应该可以吧，不过我不会，继续关注！！

[saucer]

抄自
http://www.able-consulting.com/ADO_Conn.htm#RemoteOLEDBProviderConnections

If 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=;"

[lindqp]

映射网络驱动器

[water_j]

GZ!

[aocool]

不好意思啊，各位。
我来领分了。
这个问题我回头一定帮你想想。
应该有可能实现。

[aocool]

我有办法了。
[e-mail]