TCPIP, ADO, and XML are used (MicrosoftXML4.0 must be installed .). It is divided into two parts: server and client. The server can be connected to multiple users at the same time. There are many methods to remotely connect to the Access database. I have answered in detail before (see the five methods listed below). I now use 3rd methods in this example (no need to use
TCP/IP, ADO, and XML are used (Microsoft XML 4.0 must be installed .). It is divided into two parts: server and client. The server can be connected to multiple users at the same time. There are many methods to remotely connect to the Access data warehouse. I have answered these questions in detail (see the five methods listed below ), this example belongs to the 3rd methods (no need to use
TCP/IP, ADO, and XML are used (Microsoft XML 4.0 must be installed .). It is divided into two parts: server and client. Multiple users can simultaneously
Connection.
Remote
ConnectionAccess
DataThere are many methods in the library. I have answered in detail before (see the five methods listed below ), this example belongs to the 3rd methods (no RDS or Web server is required ).
Remote
ConnectionAccess
DataLibrary methods:
1. Create a VPN (Virtual Private Network ).
ConnectionIt is similar to the LAN, and then share the Folder where the mdb file in the server is located. ADO
ConnectionAs follows:
OConn. Open "Provider = Microsoft. Jet. OLEDB.4.0; Data Source = \ ServerName \ DatabaseFolder \ Database. mdb; Jet OLEDB: Database Password = databasepw; Persist Security Info = False"
2. Place the Database on the Web Server so that ADO or RDO can be implemented through RDS (Remote Data Service) and IIS:
If odbc dsn is set on the server as mentioned in the above Jave Daxia:
OConn. Open "Provider = MS Remote ;"&_
"Remote Server = http: // myServerName ;"&_
"Remote Provider = MSDASQL ;"&_
"DSN = AdvWorks ;"&_
"Uid = myUsername ;"&_
"Pwd = myPassword"
If you set ole db Provider:
OConn. Open "Provider = MS Remote ;"&_
"Remote Server = http: // myServerName ;"&_
"Remote Provider = Microsoft. Jet. OLEDB.4.0 ;"&_
"Data Source = c: \ somepath \ mydb. mdb ",_
"Admin ",""
3. Write your own server program and pass the Recordset through TCP/IP.
4. Use third-party controls, such as ADO Anywhere or UDAParts RDB. View Details
Http://www.adoanywhere.com
Http://www.udaparts.com/
5. Use XMLHTTP
Appendix
Remote
ConnectionSQL Server method:
ConnStr = "Provider = SQLOLEDB.1; Network Library = DBMSSOCN; Persist Security Info = True; User ID = UserName; Password = Password; Initial Catalog =
Remote
DataDatabase Name; Data Source = 203.129.92.1"
