主页

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

zjgj 2002-05-05 04:57:59

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

...全文

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

aocool 2002-05-10

我有办法了。
xnily@163.com

回复赞

aocool 2002-05-10

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

回复赞

water_j 2002-05-05

GZ!

回复赞

lindqp 2002-05-05

映射网络驱动器

回复赞

saucer 2002-05-05

抄自
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=;"

回复赞