Home  Fees/Services  Access Examples  Programming Tutorials  Access Download  Articles  Search  Contact  Privacy  Links
  Connect to a Remote Access Database with ADO Activex
 Using Activex ADO Remote Database Connections







Connect String to Access DSN

Connect String to OLEDB Provider for Jet

Database Connect String to Remote Database

ADO File-DSN Database Connection String

Access DSN-Less Connection String

SQL/Server ODBC Database Connection Method Example

OLE DB UDL Database Connection String Example

Connection Open Method String Example

Microsoft Office:
  MS Access 2003
  Access 2007
  Access 2010
  Access 2013


Using the OLE DB Provider for Microsoft Access on a Remote Computer

This examples show the method for the OLE DB Microsoft Access on a remote database:

Dim conn as ADODB.Connection
Dim rst as ADODB.Recordset
Dim sql as string
'---------------

Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & _
                   "Server=remote_website; & _
                   DBQ=" & Server.MapPath("remote_database")

remote_website = the url to the website where the remote database exists, such as http://www.blueclaw-db.com

remote_database = the name of the database located on the remote computer, such as Customers.mdb

'--------------  here we use the connection

sql = "select sales_rep, dollars from sales_by_rep_chart"

Set rst = Server.CreateObject("ADODB.Recordset")
rst.Open sql, conn, 3, 3
Set Session("mysession") = rst
rst.movefirst
response.write rst!sales_rep

'--------------

Where mysession is any name for the session.

When done with the recordset don't forget to close it:

Conn.close
set conn=nothing

 



You did not know that nearly 100 cable and satellite tv installers use our software to manage their device inventory. They never lose track of an expensive device.

Did you know that most template databases often do not do exactly what you need done? We can create a custom template that fits your needs exactly.












A Blue Claw Database Design Article:

Repair Corrupted Access Table
 





Blue Claw Database Design Downloadable Tutorial:
DoCmd.OpenForm & OpenArgs VBA Example.  





A Blue Claw Software Design Template:

Real Estate Marketing Campaign System
 




Contact Information

Copyright 2000-2017 Blue Claw Database Design