Charlotte Foust
cfoust at infostatsystems.com
Wed Jul 22 10:34:46 CDT 2009
I have but I missed seeing that. If you're using Batch Optimistic you would have to use BatchUpdate. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Wednesday, July 22, 2009 8:26 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] ADO Question Try just using adLockOptimistic. You are using Batch Optimistic, and I believe that it is waiting for 'batch' commands. I must admit I have never used batch processing with ADO...go figure. Drew