Solved: Delete Query Problem

[MDY]

Hi,
I know that this isn't quite a VBA problem but i'm trying to get this delete query to run through with no luck. I am able to view the data correctly as per the view table option however recieving this error when i try to run the query. Please see error attached. Any help would be much appreciated.

Thanks
MDY:dunno

[rconverse]

My initial guess is that there is a relationship setup and that is why you are unable to delete the records.

[MDY]

Hi R Converse, Thats OK i've rewritten all my queries. The initial problem was that the records for the where table needed to be made primary keys before anything would run through and the way that the database was setup there were some text to number links that were causing problems.

Thanks for your help anyway.
MDY

[asingh]

Hi,

Please could you post the SQL version of this query..will have a look.

[asingh]

Ooops...sorry was solved..apologies.....!!