Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Toronto, Canada

    Unanswered: Office Automation and DB VB

    With VBA, i'm finding different methods ppl use to enter a db.
    Some use the ADODB.Connection, like

    Dim CurConn As ADODB.Connection
    Set CurConn = New ADODB.Connection
    With CurConn
    Dim rstCount As ADODB.Recordset
    .Provider = "Microsoft.Jet.OLEDB.4.0"
    .ConnectionString = "data source= " & CurrentDb.Name

    while others use

    Dim db As DAO.Database
    Set db = DBEngine.Workspaces(0).OpenDatabase("NameofDatabas e")

    By the time i wrote this line, i'm thinking ADO - Active data objects and DAO - Data Access Objects ; two different methodolgies i guess;

    Is one better than the other? Versatility?

    i'm creating an automation feature for Word, and i was wondering which would be better. Are there any websites that offer good tutorials on this topic of Word Automation in Access? Thx

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    oooh! politics.

    mr. gates say use ADO (you react to this however you would normally react to mr. gates' prognostications)

    depending where you look on the web you will find addicts of both, each slamming the other. each claims the other is faster/more flexible/whatever...

    personally, so far, i didn't find anything that DAO 3.6 didn't do except install the 3.6 library by default from a2k+

    currently using SS 2008R2

  3. #3
    Join Date
    Jan 2004
    Toronto, Canada
    Thx, yeah, i was leaning towards DAO; it seems less wordy to me...ADO seems too much code for a simple task but meh, thats me..

    Do you know where i can find tutorials to implement word automation.. like Dim something as Word.Application.
    objWord.Visible = True
    Set docWord = objWord.Documents.Open(sFileName, True)
    blah blah


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts