How to connect to the access database remotely (such as via the Internet)
Some time ago, many people asked about how to connect to the access database remotely (such as via the Internet). Recently, I wrote an example to share with you:
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. Establish 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 is located. The ADO connection is as follows:
"Provider=.4.0;Data Source=\\ServerName\DatabaseFolder\;Jet OLEDB:Database Password=databasepw;Persist Security Info=False"
2. Put Database on Web Server, so that ADO or RDO can be implemented through RDS (Remote Data Service) and IIS:
If the server sets ODBC DSN like Jave said above:
"Provider=MS Remote;" & _
"Remote Server=http://myServerName;" & _
"Remote Provider=MSDASQL;" & _
"DSN=AdvWorks;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
If the OLE DB Provider is set:
"Provider=MS Remote;" & _
"Remote Server=http://myServerName;" & _
"Remote Provider=.4.0;" & _
"Data Source=c:\somepath\", _
"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 out specific
/
5. Using XMLHTTP
6, first use asp to read out some numbers, and then remotely obtain ajax
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
Attached: How 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.
Some time ago, many people asked about how to connect to the access database remotely (such as via the Internet). Recently, I wrote an example to share with you:
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. Establish 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 is located. The ADO connection is as follows:
"Provider=.4.0;Data Source=\\ServerName\DatabaseFolder\;Jet OLEDB:Database Password=databasepw;Persist Security Info=False"
2. Put Database on Web Server, so that ADO or RDO can be implemented through RDS (Remote Data Service) and IIS:
If the server sets ODBC DSN like Jave said above:
"Provider=MS Remote;" & _
"Remote Server=http://myServerName;" & _
"Remote Provider=MSDASQL;" & _
"DSN=AdvWorks;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
If the OLE DB Provider is set:
"Provider=MS Remote;" & _
"Remote Server=http://myServerName;" & _
"Remote Provider=.4.0;" & _
"Data Source=c:\somepath\", _
"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 out specific
/
5. Using XMLHTTP
6, first use asp to read out some numbers, and then remotely obtain ajax
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
Attached: How 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.