Clearing data?

  • Thread starter Thread starter access dummy
  • Start date Start date
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.
 
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.
 
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.
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Clear all records in access 2
Record-Locking remains open after closing 0
Search access Macros, Forms and VBA code for a specific table references 2
Excel How do I delete images in a specific range 1
Images in an Access field 2
Remote Database and Office Database 15
receiving error "id" is not an index in this table error 3800. 1
Dropping the ODBC connection 8

Back
Top