TCP/IP, ADO and XML are used (Microsoft XML 4.0 is required to be installed.). It is divided into two parts: server and client, and the server can be connected at the same time by multiple users. There are many ways to connect to the Access database remotely. I have answered it in detail before (see the 5 methods listed below). My example now belongs to the third method (no need to use RDS or web server).
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
Several ways to remotely connect to the access database:
1. Create a VPN (Virtual Private Network) so that the connection between your computer and the host is no different from that of the LAN, and then share the Folder where the mdb file in the server. The ADO connection is as 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. Put Database on the Web Server and enable ADO or RDO to be implemented through RDS (Remote Data Service) and IIS:
If the server sets up ODBC DSN as Jave said above:
oConn.Open "Provider=MS Remote;" & _
"Remote Server=http://myServerName;" & _
"Remote Provider=MSDASQL;" & _
"DSN=AdvWorks;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
If the OLE DB Provider is set:
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 the server program yourself, pass Recordset through TCP/IP.
4. Use third-party controls such as: ADO Anywhere or UDAParts RDB, etc. Check it out in detail
5. Using XMLHTTP
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
Attached is a method to remotely connect to SQL Server:
ConnStr = "Provider=SQLOLEDB.1;Network Library=DBMSSOCN;Persist Security Info=True;User ID=UserName;Password=Password;Initial Catalog=Remote Database Name;Data Source=203.129.92.1"
Attachment: [Remote call ACCESS database] Remote call ACCESS database.rar (2006-6-28 08:29, 1.08 K)