How to remotely connect to the access Database

Some time ago, many people asked how to connect to the access database remotely (such as through the Internet). I recently wrote an example to share with you: Using TCPIP, ADO and XML (MicrosoftXML4.0 must be installed .). It is divided into two parts: server and client. The server can be connected to multiple users at the same time. Many users remotely connect to the Access Database

Some time ago, many people asked how to connect to the access database remotely (such as through the Internet). I recently wrote an example to share with you: using TCP/IP, ADO and XML (Microsoft XML 4.0 must be installed .). It is divided into two parts: server and client. The server can be connected to multiple users at the same time. Many users remotely connect to the Access Database

Some time ago, many people askedRemote(For example, through the Internet)ConnectionAccessDatabaseOfMethodRecently, I wrote an example to share with you:

TCP/IP, ADO, and XML are used (Microsoft XML 4.0 must be installed .). It is divided into two parts: server and client. Multiple users can simultaneouslyConnection.RemoteConnectionAccessDatabaseThere are manyMethod, I have answered in detail before (see the five types listed belowMethod). Now, this example belongs to 3rd of them.Method(RDS or Web server is not required ).

-------------------------------------

RemoteConnectionAccessDatabaseOfMethod:

1. Create a VPN (Virtual Private Network ).ConnectionIt is similar to the LAN, and then share the Folder where the mdb file in the server is located. ADOConnectionAs follows:

　　 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 through RDS (Remote Data Service) and IIS:

If odbc dsn is set on the server as mentioned in the above Jave Daxia:

　　 oConn.Open "Provider=MS Remote;" & _
　　　　　 "Remote Server=http://myServerName;" & _
　　　　　 "Remote Provider=MSDASQL;" & _
　　　　　 "DSN=AdvWorks;" & _
　　　　　 "Uid=myUsername;" & _
　　　　　 "Pwd=myPassword"

If you set ole db Provider:

　　 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 the Recordset through TCP/IP.

4. Use third-party controls, such as ADO Anywhere or UDAParts RDB.

5. Use XMLHTTP

--------------------------------------

AppendixRemoteConnectionSQL ServerMethod:

ConnStr = "Provider = SQLOLEDB.1; Network Library = DBMSSOCN; Persist Security Info = True; User & nbs
P; ID = UserName; Password = Password; Initial Catalog =RemoteDatabaseName; Data Source = 203.129.92.1"