Ways to connect to an Access database remotely

Source: Internet
Author: User
Tags dsn connect access database
access| Data | A lot of people ask remote (such as over the Internet) how to connect Access database, recently wrote an example to share with you:

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:

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 a Web server so that ADO or RDO can be implemented via RDS (Remote Data Service) and IIS:

If the server has ODBC DSN set up like the above, Jave:

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:somepathmydb.mdb", _
"Admin", "" "

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

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

5. Using XMLHTTP
--------------------------------------

Attach remote connection to SQL Server method:
ConnStr = "Provider=SQLOLEDB.1; Network LIBRARY=DBMSSOCN; Persist Security info=true; User&nbs
P;id=username; password=password;initial catalog= remote database name; Data source=203.129.92.1 "

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.