Intermittent query issues

[Sherry]

I have converted an Access database from 2003 to 2007. It is dependent on other databases (that were also converted) for tables. I am getting intermittent query issues per 'Cannot delete from specified tables' and 'Operation must use an updateable query'. This tool is used by a single user at a time. The 2007 version is running on a beefier laptop and does run faster than the 2003 version on the less beefy laptop.

I put debug.print statements in to help troubleshoot where the issue is occuring. It is simply not consistent on which records it occurs and how often the errors occur. Actually, putting in the debug.print statements slowed it down a little, so the errors do seem to be reduced; however, sometimes it runs fine, and other times the errors show up. Sometimes the error is 'cannot delete...', sometimes it's 'operation must use...', but most of the time, both show up at various times.

I have:
(1) Changed the 'Unique Records' setting to "Yes" on the delete and update queries being called via code (i.e., with query defs or db.execute)


(2) Put in a Timer routine to wait whenever a delete routine is being called and between the query def definition and setting the query parameters and executing it.

Any ideas would be greatly appreciated...

[orange]

I am getting intermittent query issues per 'Cannot delete from specified tables' and 'Operation must use an updateable query'.

If you attempt to delete a record in a parent table (the 1 table in a 1 to many relationship) you may have conditions set that would NOT allow the records in that table to be deleted unless all child records have been deleted first. I'm not saying that is the issue, but it could be some structural constraint.

Do you know the name of the query? Can you post the SQL for that query? Can you also show your relationships in a jpg?

Here is a link discussing some of the rationale behind -Operation must use an updateable query.
http://allenbrowne.com/ser-61.html