hi there,

i have 2 tables which i am now trying to merge together and it wont let me delete the duplicate records. I have a unique number on each record in one table and the same unique number exists in the second table (not autonumber though). I check to see which ones are duplicated and then if certain conditions are met, i need to delete from the second table, but access says that i cant delete as it is read only - why? This is using a delete record query.

None of the files are read only and i can delete the records in the normal table view, but there are about 10,000.

If you have any ideas, please let me know,
Cheers,
Sparky