Jim Dettman
jimdettman at verizon.net
Wed Jun 17 07:06:08 CDT 2009
John, FWIW, you might want to check this out: ACC2000: How to Trap Specific ODBC Error Messages http://support.microsoft.com/kb/209855 but you may already be doing this (using the errors collection) as you mentioned seeing two ODBC errors. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Tuesday, June 16, 2009 5:26 PM To: Access Developers discussion and problem solving Subject: [AccessD] Trap ODBC failures How do you trap ODBC failures? For example an index prevents a record being added to a form, I get an ODBC error message (actually two) but it doesn't seem to be occurring in code that I can break into and trap the error. -- John W. Colby www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com