View Single Post
  #13 (permalink)  
Old October 2nd, 2003, 02:54 PM
Bob Bedell Bob Bedell is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Hi Sam,

Glad to here you got it going.

In ADO the Connection object does double duty compared to DAO.

In DAO the Workspace object defines the session for a user and the Database object defines a data source.

In ADO the Connection object does both. It defines a session for a user for a data source. The conversion looks like:


' DAO
Dim dbs as DAO.Database
Set dbs = DBEngine.Workspaces(0).OpenDatabase(".\Northwind")


' ADO
Dim cnn as New ADO.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\Northwind.mdb;"

(though there are several ways to write these statments)

HTH,

Bob

Reply With Quote