[AccessD] Access 2000 error

The default install of MDAC on WinXP is 2.7
If you have multiple installs of  MDAC on your system. the highest level 
of the MDAC points to
MSADO15.dll  Lower levels of ADO  MDAC point to a .tlb file like MSADO26.tlb
 On  my system I have Access 97 and 2003 installed so I have MDAC 2.1 
installed as well due to 97 being there.
 So my selection of references is
 ADO  2.7  ---- MSADO15.dll
 ADO  2.6  ---- MSADO26.tlb
 ADO  2.5  ---- MSADO25.tlb
 ADO  2.1  ---- MSADO21.tlb
I would check what file your references are pointing to.
You may not have MDAC 2.1 installed on one of your machines,  this MDAC 
is available as a seperate
download from http://www.microsoft/data and is only installed with lower 
versions of Access.
Also some of these MDAC's like 2.5 have up to 3 SP's.
MDAC 2.7 and 2.8 don't run on Win95
I would pick one MDAC depending on your OSes and standardize on it. 
Remembering each OS version comes with a specific level of the MDAC.

Doug Murphy wrote:

>The ActiveX Data Objects 2.1 (ADO) is checked I just reversed the order
>of the words in my original message. My dyslexia is showing.  Tried 2.5
>and got the same message.
>
>This may be one of the AccessXP/2000 anomolies.  When I move the DB to
>my XP development machine it works fine.  It compiles on both machines.
>???
>
>Doug
>
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
>DWUTKA at marlow.com
>Sent: Monday, April 12, 2004 11:33 AM
>To: accessd at databaseadvisors.com
>Subject: RE: [AccessD] Access 2000 error
>
>
>That is DAO you have set.  You need ADO, which is Microsoft ActiveX Data
>Objects. (I personally set 2.5)
>
>Drew
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Doug Murphy
>Sent: Monday, April 12, 2004 1:09 PM
>To: 'Access Developers discussion and problem solving'
>Subject: [AccessD] Access 2000 error
>
>
>Folks,
>
>I inherited an Access 2000 database to do some work on.  I have not done
>anything to the wizard built switchboard but it now breaks an the line
>"Set con = Application.CurrentProject.Connection".  Checked the
>references and MS data objects active-x library 2.1 is checked.  When I
>type in the same line auto completion fills in all the correct items so
>the terminology is correct for the given references.  Any idea why this
>thing is breaking?
>
>Doug
>
>
>
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby
>Sent: Sunday, April 11, 2004 7:14 PM
>To: AccessD
>Subject: [AccessD] Framework Discussion page rebuild
>
>
>I have gone through all of the discussions and built a specific mdb and
>matching document zipped as a pair in a zip file.  The framework
>discussion page on my site now has 12 "chapters" built in this manner.
>This should make following the document easier.  Anyone going through
>the new document / database who finds any issues please email me offline
>to let me know and I will attempt to get such issues fixed and reposted.
>I did have to go carve out some of the chapters from the databases where
>I had just updated the db for several chapters so there may be a few
>issues.  Again, I will attempt to fix any issues brought to my attention
>and repost.
>
>In the future, all documents will be built with a matching database as
>the document is written and so should match "exactly".
>
>More are on the way.  I use a class for Openargs that parse the args and
>apply known framework args directly.  This lecture is almost finished.
>If anyone has any suggestions for future lectures please contact me
>offline or post them here if you want to stimulate discussion.
>
>John W. Colby
>www.ColbyConsulting.com
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada