• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 476
  • Last Modified:

Microsoft Access 2002/2003 References Activex Data Objects

Dear Experts,

What is the difference between check the Microsoft Activex Data Objects 2.1 Library VS Microsoft ActiveX Data Objects 2.8 Library?

TIA

Regards,
Antonio Macias
0
rebelscum0000
Asked:
rebelscum0000
  • 5
  • 2
5 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Basically 2.8 is a new, updated version ... compatible with later versions of Access.

mx
0
 
Leigh PurvisDatabase DeveloperCommented:
Well ADO 2.8 is the most recent anyway - wouldn't exactly say it's new any more. ;-)
(It's all "ADO Classic" now).

FWIW I'll often start a project with the default (2.1) selected until I need something it doesn't offer.
(It makes it being already present on a target OS that much more likely... however that isn't really a consideration - as I suspect 2.8 has been included since XP...)

The main difference to my mind came with 2.5 - and you'll want that if you have need of, say, a Stream object - or named params in a command.

Those aside - you'll find the same fundamental objects present.  (After all - ADO really only consists of the three primary ones :-).
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
ahh ... I meant ... NewER :-)

my bad
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
oleggold:

Whereas that link is sort of cool ... it's a tad outdated .... since DAO (see below) is anything but obsolute :-)
Obsolete components

Several components have been completely removed from MDAC by Microsoft and are no longer supported. They are:


    * DAO: DAO, or Data Access Objects were an object oriented interface created by Microsoft which allowed early versions of Microsoft Access and Visual Basic to access the Jet database engine. Later (in version 3.5) it was able to bypass the Jet engine
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
<ot>
Hey Leigh ... while you are here ...
Question.  I have read this:
Say you have a (Select) query in design view in the query grid ... 2-3 tables, nothing special.  You make some changes (new fields, sorting, whatever).  According to what I read ... JET optimizes the query - creates the 'plan' when you Save in design view ... against the existing data at that time ... as opposed to ... when you actually Run the query (from say the query grid)  *after* saving it.  In fact, it says that IF .... you Run the query (from the query grid) ... and then Save again ... the plan goes away.

What is the reality here?

thx.mx

<ot/>
0
 
Leigh PurvisDatabase DeveloperCommented:
Hi MX.
Sorry not gotten to look at this before now... just been pretty busy and don't get over to EE all that often anyway these days.

IMO saving a querydef definition results only in the SQL being parsed.  If the SQL is valid then it's committed to the definition. (It's here that nasty things can happen to well formatted SQL - especially subqueries).
Compiling and forming an optimized execution plan occur only when executing the query (that first time).
Subsequent calls to the query use that plan - until it has cause to be re-compiled (e.g. by editing the query or compacting the database).

Saving again *might* cause the plan to be removed... if Access perceives that an edit took place (generally you'd want to be pretty specific about this - making an actual edit... even if it's superficial/temporary - but saving again might be interpreted as an edit by Access).
But only upon executing the query should optimisation and plan saving occur.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Thanks Leigh.  That would be my guess also.  I think this article got it backwards, which prompted this question. My impression has always been that it occurs when 'first' run after an edit/save or compact operation. I don't see how ... until it was run against the current data set any optimization could occur. I will did up that article and review what it said.

"and don't get over to EE all that often anyway these days."
np ... more points for me , HA HA :-)  (but PLEASE - stop by when you can!!!)

thx.mx
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now