 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2008Problem with Delete query! *5122008
Dear all , I have a table(A) wich contains following f.e. records: 1 2 3 4 and I want to create a delete query which only deletes records 2 + 3 from (A); I then made a make table(B) query (which only contains the records 2+3 from (A)) then I designed a new simple query wizard linking (A) and (B) named (C)! Then I designed a new delete query for (C) and I put in an asterix ,when I try too run it I get foll message "COULD NOT DELETE FROM SPECIFIED TABLES" But when I open (C) it self and start deleting records one by one it does work ,but obviously its not very efficient! What am I doing wrong? Regards! J.Alladien, there is more to this problem than you have explained in the post. I am assuming that you want a delete query that you can use on the same table on many different occasions. Some more detail about this table, the relevant fields and any relationships with this table and other tables would help us volunteers to provide a helpful answer. Jeanette Cunningham -- Melbourne Victoria Australia > Dear all , > [quoted text clipped - 19 lines] > What am I doing wrong? > Regards! Dear Jeanette, I already found a way to solve it, Thanks! Regards > J.Alladien, > there is more to this problem than you have explained in the post. [quoted text clipped - 29 lines] > > What am I doing wrong? > > Regards! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.