Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

Thread Tools Rate Thread Display Modes
Old 12-06-2018, 05:27 PM   #16
Sr. Application Developer
Join Date: Jun 2011
Posts: 2,619
Thanks: 113
Thanked 295 Times in 283 Posts
mdlueck will become famous soon enough mdlueck will become famous soon enough
Re: Attempting to use ADO Disconnected Recordset VBA style for non SELECT queies

Greetings Scott,

Originally Posted by Frothingslosh View Post
The key is that you make bloody well certain that you don't reset the error collection, which means no execution of any kind of On Error statement. Maybe passing the DAO object did that on its own.
Quite possibly. Anyway, I came to the conclusion that DAO objects were more fragile than ADO, and had to find a work around... which I did.

Originally Posted by Frothingslosh View Post
Using that error handler, I have successfully reported 4- and 5-part SQL Server errors, and every error from SQL Server includes at least two errors, as the first one is the basic 'failure' one that is what most error handlers display.
I believe I only ever saw two errors in the DAO error collection in my time working on this application. Yes, SQL Server 2008 was the BE DB in this case.

I am thankful,

Michael Lueck
Lueck Data Systems

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
mdlueck is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
disconnected ADO recordset as report source dclosure Visual Basic 1 09-28-2012 04:11 AM
Filters fails with ado disconnected recordset awf.franco General 1 06-09-2010 04:49 AM
UpdateBatch on disconnected recordset butler01 Modules & VBA 0 09-10-2009 07:48 AM
Show Disconnected Recordset in ListBox jal Modules & VBA 2 12-28-2008 06:02 PM
Set forms recordset to a disconnected ADO recordset Kodo Modules & VBA 7 06-07-2004 12:23 PM

All times are GMT -8. The time now is 03:52 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World