TCP/IP, ADO and XML are used (Microsoft XML 4.0 needs to be installed.). It is divided into two parts: server and client. The server can be connected by multiple users at the same time. There are many ways to remotely connect to the Access database. I have answered it in detail before (see the 5 methods listed below). My current example belongs to the third method among them (no need to use RDS or Web server).
Several methods for remote connection to access database:
1. Establish a VPN (Virtual Private Network) so that the connection between your computer and the host is the same as a LAN, and then share the Folder where the mdb file in the server is located. The ADO connection is as follows:
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\ServerNameDatabaseFolderDatabase.mdb;Jet OLEDB:Database Password=databasepw;Persist Security Info=False"
2. Put the Database on the Web Server and enable ADO or RDO through RDS (Remote Data Service) and IIS:
If the server has set up an ODBC DSN like the Java hero said above:
oConn.Open "Provider=MS Remote;" & _
'www.downcodes.com
"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:somepathmydb.mdb", _
"admin", ""
3. Write your own server program and pass Recordset through TCP/IP.
4. Use third-party controls, such as ADO Anywhere or UDAParts RDB, etc. For details, please check
5. Using XMLHTTP
-----------------------------------------
Attached is the method of remote connection 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"