I thought some more about this as I read the posts today. Bulk deleting all the
records and adding new records to a database is not a good idea. You will find
that the file size exponentially grows in size. The better alternative is to
create a blank database then each week delete your existing database, make a
copy of the blank database and rename the copy to the name of the original
database.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
"Houston" <ho*****@hbip.com> wrote in message
news:LI*************@newssvr24.news.prodigy.com...
I have a database that needs to be cleared (no records in it) once a week on
a specific day. Is there some way to generate a command that will do this or
some other way perhsps?
Cheers
Houston