By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,665 Members | 1,251 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,665 IT Pros & Developers. It's quick & easy.

Delete query help

P: n/a
I'm trying to create a delete query from tableA that has the same
records in the paste errors table. tableA has records that were
previously inputed. New data coming in has information of old data
from tableA where the values may have changed. Upon inputting the new
data into tableA, records with the same primary key (field: PO) are
put into the paste errors table since it will cause duplicates. I've
created a delete query having joins at the primary key between the
paste errors and tableA. Delete * from tableA, where [paste
errors].[PO]. This did not work so I've also tried Delete * from
tableA, where [tableA].[PO]. This did not work either. When I
switched from design view to datasheet view the correct records are
showing up but will not run once I click the "RUN" button. Error that
shows up is "Could not delete from specified tables" Error 3086.

There seems to be a permission problem or that the database is
"read-only". I am the adminstrator of the database so have all the
rights and permissions. The database is not open for read-only.
Database is split into front-end/back-end with security setup.

Any suggestions would be greatly appreciated.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.