External Parameter Delete Query

[shannonphillips]

I have 2 copies of my master Table in other DB's, which needs to be updated once a day. The easiet is to delete all and append all, however this is getting to be to large of a task.

I have created a table with single field to store a (record_change_date) value in, then tie all 4 of my queries (one delete and append per table) to this field for the matching criteria.

This works great for the append queries, and shows the correct matching criteria for the delete queries, however when trying to run the delete queries is just says "Cannot delete from spefic table"

Any ideals?

Thanks
Shannon

 

[PHV]

Any ideals?
I've a lot of ideals but NO idea without seeing your SQL codes.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[shannonphillips]

I don't develope at the SQL level.

I have a table(A) with a single stored value in a field, which I link to my master table(B) and the delete query finds the correct citeria, however it will not delete that set of records from a 3rd linked table(C) in another db.

Happy Holidays,
Shannon

 

[shannonphillips]

I got it,

Although the linked tables for the criteria(A&B) where finding the correct records, Table A did not have a primary key define.

Table A now has a primary key and the delete query works just fine.

Shannon