N
NewtoComputing
HI.
I have used an SQL union query to join 2 tables and created a table from
this query.
Then i've used a totals query to identify duplicate records based on date.
Then i've created a delete query to get rid of the duplicate records.
I've followed all instructions thoroughly and there are no relationships
between the tables in the delete query and other tables. I also have
permission to access and amend any part of the database yet I am still faced
with the message that I "can't delete from specified tables".
What am I missing?
Thanks
I have used an SQL union query to join 2 tables and created a table from
this query.
Then i've used a totals query to identify duplicate records based on date.
Then i've created a delete query to get rid of the duplicate records.
I've followed all instructions thoroughly and there are no relationships
between the tables in the delete query and other tables. I also have
permission to access and amend any part of the database yet I am still faced
with the message that I "can't delete from specified tables".
What am I missing?
Thanks