Using a Delete Query
I need to create a Delete Query to clear out the data from tables in my database. The description in my Professional Features book is sparse: "DELETE [table,*] FROM tableexpression WHERE Criteria"! I want to renumber the RecordIDs (1st field, Long) in my DB, which got fouled. The procedure I'd like to follow is to COPY the DB, then use the Delete Query to empty the tables, leaving the structure, then copy the original table data into the Copied DB renumbered. I do not understand what[table,*} or tableexpression is supposed to mean in this context. I can see starting with "DELETE tablename FROM" but can't figure out what goes next! My everyday SQL statement looks like ""SELECT * FROM [" + zpTableToAddTo + "]"." Can I get away with "DELETE tablename" ?