Creating an Empty copy or nearly empty copy of Access DB

B

BriMan

I'd like to remove all the entries from an access DB save
for several categories/fields. Is there a Macro or Query I
can run that will allow me to only have to Select the
entries in the "exception fields" that I want save and
delete everything else(all the other normal "form"
entries)? Been looking online and I thought I saw this
process listed yesterday, but today, I can't seem to Locate
the web page that explained how to do it...TIA, BriMan
 
N

Nikos Yannacopoulos

BriMan,

For each table you wish to clear some fields of: Make a simple query on the
table, and include the fields to be cleared in the grid. Then go to meny
item Query > Update Query; notice the new line Update To in the grid. Next,
type "Null" (without the quotes) in this line under every field you wish to
clear out, and run the query (Query > Run). The job is done.

Word of caution: before you do anything, make a backup copy of your
database!

HTH,
Nikos
 
Top