I want to start fresh with an old database, how do I delete the o.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im re doing our chemical register and want to 'clear' all the old data that
has been entered over the years and start again, I want to use the old
database though.

Can you tell me how to go about doing this?
 
In each table, highlight all the records and press the delete key. If you
have specified relationships and referential integrity, you will need to do
this from the "bottom up" -- that is from the lowest level of the "many"
side of one-to-many relationships up to the highest. Alternatively, you
could temporarily remove the relationships.

Rather than manually having to highlight all the records, executing a delete
query can remove all the records (subject to the same qualifications as
above). You can create the delete query for each table in the Query Builder.
The final SQL for each would look something like this:

DELETE * FROM <thetablesname>;

Larry Linson
Microsoft Access MVP
 
Im re doing our chemical register and want to 'clear' all the old data that
has been entered over the years and start again, I want to use the old
database though.

Can you tell me how to go about doing this?
Click to expand...

One way is to create a new, empty .mdb file; use File... Get External
Data... Import to import everything. Select the option to import
tables "design mode only", rather than importing the data in the
tables.

You may very well have some tables (lookup tables in particular) that
you want to salvage - these can be imported separately, with the
import data option turned on.

John W. Vinson[MVP]
(no longer chatting for now)
 
Back
Top