[AccessD] Query Puzzler

Can you post the SQL? 

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Sunday, October 11, 2009 7:37 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Query Puzzler

I have a named delete query which seems to perform as expected when executed
from the database window (well, I haven't actually executed it, but only
displayed the result grid) but when I try to run said query from code I get
the following error message:
Error #3709-The search key was not found in any record.

I have gone through the usual suspects (compact and repair, recompile, etc.)
with no solution yet. It's driving me nuts (a short drive to be sure).

Any ideas, anyone?

TIA,
Arthur
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com