Shulou(Shulou.com)05/31 Report--

Editor to share with you how to remotely connect to the access database, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The method of connecting to access database remotely (as through the Internet)

Some time ago, many people asked how to connect to an access database remotely (such as through the Internet). Recently, I wrote an example to share with you:

TCP/IP,ADO and XML are used (Microsoft XML 4.0 is required. ). It is divided into two parts: the server and the client, and the server can connect to multiple users at the same time. There are many ways to remotely connect to an Access database, which I have answered in more detail before (see the five methods listed below), and my example now belongs to the third of them (no RDS or Web server is required).

--

Several ways to remotely connect to an access database:

1. Set up VPN (Virtual Private Network) so that the connection between your computer and the host is the same as the local area network, and then share the Folder where the mdb file is located in the server. 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 Web Server, so that ADO or RDO can be realized through RDS (Remote Data Service) and IIS:

If the server has ODBC DSN set up as the warrior Jave said above:

OConn.Open "Provider=MS Remote;" & _

"Remote Server= http://myServerName;" & _

"Remote Provider=MSDASQL;" & _

"DSN=AdvWorks;" & _

"Uid=myUsername;" & _

"Pwd=myPassword"

If 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 by yourself and pass the Recordset through TCP/IP.

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

Http://www.adoanywhere.com

Http://www.udaparts.com/

5. Use XMLHTTP

6. Read out some numbers with asp, and then get ajax remotely.

--

The above is all the contents of the article "how to connect to an access database remotely". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.