[AccessD] Access 2000 error

Doug Murphy dw-murphy at cox.net
Mon Apr 12 16:58:20 CDT 2004


For what ever it is worth the error is apparently caused by the version
of Jet on the machine.  I installed the latest jet 4 service pack and
the problem went away.  Found a vague reference to this on the MS
knowledge base.

The original cause may have been that I was working on the DB in Access
XP/2000 format.  I then moved a copy to an actual version of Access 2000
on another machine to test before sending off to the customer.  After
hosing a previous DB I am carefull to open and recompile a DB when
moving back and forth between XP and 2000, but this seems different than
the vb6 dll thing.

Doug





-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Monday, April 12, 2004 11:44 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Access 2000 error


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


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list