Clearing data?

A

access dummy

I need to clear all of the data in a access database, but
keep all of the fields.

Does anyone know of a way to do this.
 
A

Allen Browne

Open the Immediate Window (press Ctrl+G), and enter:
dbEngine(0)(0).Execute "DELETE FROM Table1;"
substituting the name of your table for Table1. Press Enter.
 
A

Access Dummy

Allen,

I should have explained better. This database has a front
end on it that doesn't allow me to get to any controls.

The way this is set up you can enter of view data, but
can not get to any controls.

Thanks again.
 
D

David DeRolph

Just click on the upper left corner of your Access table to select all
records. Then, right click and click on Delete Record. All records will be
deleted.
 
A

Access Dummy

Thanks Guys, I figured it out.

I couldn't get to the tables. But if you hold down the
shift key while it's opening, you can get to them.


Thanks Again.

Signed,

Slightly less dumb.
 
Top