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

zjgj 2002-05-05 04:57:59
请问各位前辈,我是个菜鸟,对VB了解不是很深,我想做一个本地维护网上的程序,所以就得先连接网上那个数据库,而网上的空间只支持ACCESS2000,我不知道用什么方法去连接它,有没有办法?我很急的,谢谢各位前辈!!!!!!!
...全文
2 点赞 收藏 7
写回复
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=;"

回复
jdsbjcailei 2002-05-05
应该可以吧,不过我不会,继续关注!!
回复
superauu 2002-05-05
连不了,你分多都给我把,嘿嘿
回复
发动态
发帖子

1180

社区成员

VB 数据库(包含打印,安装,报表)
申请成为版主
社区公告
暂无公告