Just glad you figured it...
--
Gina Whipp
2010 Microsoft MVP (Access)
http://www.regina-whipp.com/index_files/TipList.htm
Post by Gina WhippBrianDP,
Did you get help for this issue?
--
Gina Whipp
2010 Microsoft MVP (Access)
http://www.regina-whipp.com/index_files/TipList.htm
When I try to delete more than one record from the subform, it sits
there and finally comes back with "ODBC--Call Failed." However if I
delete the records one at a time, the records get deleted.
Why can't my users delete more than one record at a time???
-BrianDP
Thanks Gina,
What I found out about this one was that the form (subform I mean) had
something like 5 different triggers to run what amounts to a
housecleaning script. Every time they monkey with anything*, the
close the record, the move off a field, they change a field, they do
just about ANYTHING, and that housekeeping script starts running.
Well, the problem wasn't occurring if you just deleted 1 record, but
apparently when you would delete 5 (or just more than 1) it was
causeing Access to get it's feet tangled somehow or other. I'm
thinking it's just getting hung up becuase for each record, it seems
like on a delete, that script would get run something like 5 times for
each record, times 5 records, this would seem to grow exponentially as
you try to copy more records. So, I took most of those triggers out.
If you add a record, or if you delete a record, the script runs.
Other than that, I took out all the other script triggers there.
Thanks again for your concern!
-Brian