After installing Microsoft XML 4.0, TCP/IP, ADO and XML are used. We know that they are divided into two parts: server and client. Generally, the server can be connected to multiple users at the same time. Do you know how to remotely call the ACCESS database? Now let’s take a look at the method of remotely calling the ACCESS database.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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 is located. 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"
The above is the wrong new technology channel to share with you the method of remotely calling ACCESS database. You may put forward some different opinions. It doesn’t matter. Leave us a message and discuss it together!