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