468,244 Members | 1,899 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,244 developers. It's quick & easy.

Delete query help

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
0 2761

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Mark Reed | last post: by
9 posts views Thread by Dejan | last post: by
3 posts views Thread by Kevin M | last post: by
3 posts views Thread by Phil Stanton | last post: by
1 post views Thread by jmarcrum | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.