How to make a remote call to an Access database method

How to invoke the Access database method remotely:

Tcp/ip,ado and XML are used (Microsoft XML 4.0 needs to be installed.) )。 Sub-server and client-side two parts, the server can connect multiple users simultaneously. There are a number of ways to remotely connect to an Access database, which I have answered in more detail (see the 5 methods listed below), and this example is the 3rd method (no need to use RDS or a Web server).

Several ways to connect to an Access database remotely:

1. Establish VPN (Virtual Private network), so that your computer and host connection is the same as the LAN, and then the server in the MDB file folder to share. The ADO connection is as follows: The following is the referenced content:

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=servernamedatabasefolderdatabase.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 via RDS (Remote Data Service) and IIS: If the server is set up ODBC DSN as above Jave said: The following are references:

oConn.Open "Provider=ms remote;" & _ "remote Server=http://myservername;" & _ "Remote Provider=msdasql ; "& _ " Dsn=advworks; "& _ " Uid=myusername; "& _ " Pwd=mypassword "

If you are setting up an OLE DB Provider: The following is what you refer to:

oConn.Open "Provider=ms remote;" & _ "remote Server=http://myservername;" & _ "Remote Provider=micro Soft. Jet.oledb.4.0 & _ " Data Source=c:somepathmydb.mdb", _ "admin", ""

3. Write your own server program, pass the recordset through TCP/IP.

4. Use third party controls, such as ADO anywhere or udaparts rdb.

5. Use of XMLHTTP

Attach a remote connection to SQL Server: The following are the contents of the reference:

connstr = "provider=sq Loledb.1; Network LIBRARY=DBMSSOCN; Persist Security info=true; User Id=username; Password=password; Initial catalog= remote database name; Data source=203.129.92.1 "