<% noads=1 %> <%dim crumb crumb="Connect to Remote DB" Crumb2="Connect to a Remote Access Database with ADO Activex" crumb1="Using Activex ADO Remote Database Connections" %> ADO OLEDB Microsoft Jet Provider for Remote Access Example
Home  Fees/Services  Access Examples  Programming Tutorials  Access Download  Articles  Search  Contact  Privacy  Links
  <%if len(crumb2)>2 then response.write crumb2 %>
 <% response.write crumb1 %>
 Home > MS Access Tutorials > Connection Strings<% response.write " > " & crumb %>

<% dim Gnum,Ynum Gnum="0957644070" Ynum="7867" dim Page_Type Page_Type="Prog" %>






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

 



















Contact Information

<% Response.write "Copyright 2000-" & year(now) & " Blue Claw Database Design" %>