远程连接access数据库的几个方法:
1.建立VPN(Virtual Private Network),这样你的电脑和主机的连接就与局域网无异,然后把服务器中mdb文件所在的Folder共享即可。ADO连接如下:
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=//ServerName/DatabaseFolder/Database.mdb;Jet OLEDB:Database Password=databasepw;Persist Security Info=False"
2.把Database放在Web Server上,使ADO或RDO通过RDS(Remote Data Service)及IIS来实现:
如果服务器像上面Jave大侠说那样设置了ODBC DSN的话:
oConn.Open "Provider=MS Remote;" amp; _
"Remote Server=http://myServerName;" amp; _
"Remote Provider=MSDASQL;" amp; _
"DSN=AdvWorks;" amp; _
"Uid=myUsername;" amp; _
"Pwd=myPassword"
acess远程连接
最新推荐文章于 2024-07-25 12:46:10 发布