Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 08-08-2009
Member
 
Join Date: Nov 2008
Posts: 240
How to specify the table containing the records you want to delete

I have a table with numerous records in it, and am attempting to delete certain records that have been selected from it. It gives me following error message saying "Specify The Table Containing The Records you want to Delete", So please let me know how do I create a record deletion system within my MS Access project so that I can store a copy of updated records into a temporary table before deleting them from a table.
Reply With Quote
  #2  
Old 08-08-2009
Member
 
Join Date: Oct 2008
Posts: 119
Re: How to specify the table containing the records you want to delete

Never tried to delete using a join; I assume that that is where the problem is. Although I also generally don,t include column names because you're deleting an entire row, not just data within those rows, a Parameter and ask the user for the Parameter value since the Table is not in the FROM clause. I'm not sure how your tables are set up. If you have set up relationships to tblPersonalInfo and have set Cascade.
Reply With Quote
  #3  
Old 08-08-2009
Member
 
Join Date: Feb 2008
Posts: 130
Re: How to specify the table containing the records you want to delete

Unfortunately none of these solves the problem I am having. It still does not know what table I was to delete from. I copied and pasted your statement below into the SQL window, and was able to perform the deletions. Changes in the Microsoft Jet database engine included with Microsoft Access 2000 cause the program to handle the SQL.
Reply With Quote
  #4  
Old 08-08-2009
Member
 
Join Date: Feb 2009
Posts: 56
Re: How to specify the table containing the records you want to delete

To resolve this error, set the query's UniqueRecords property to No by following these steps:
  1. Open the select query in Design view.
  2. If the property sheet is not already open, on the View menu, click Properties.
  3. Click an empty area in the upper half of the query window so that the property sheet displays "Query Properties" in the title bar.
  4. Set the UniqueRecords property to No.
  5. Save the query, close it, and then run the query. Note that you may now update the data in the query.

SOURCE:http://support.microsoft.com/?id=207761
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to specify the table containing the records you want to delete"
Thread Thread Starter Forum Replies Last Post
PHP - I want to retrieve records from specific field from a MySQL table and build array using PHP bond007dev Software Development 3 19-07-2010 04:23 PM
SQL Query For Copy records from one table to another Bellamy Software Development 4 23-05-2010 12:36 AM
PHP mysql select unique records from one table Captain Carrot Software Development 6 13-05-2010 12:18 PM
Select unique records from a table Conraad Software Development 5 13-05-2010 12:01 AM
Unable to delete records from Two Joined table Broot Software Development 3 22-09-2009 03:44 PM


All times are GMT +5.5. The time now is 01:08 PM.