tidying up old database

[Jeff Boyce]

Why do you believe the database is "getting too large"?

Have you already made a backup, then used Compact & Repair? (where you find
this depends on which version of Access, unmentioned in your post).

"Remove any files" doesn't really make sense if you're describing an Access
database, which is a single file. Are you saying you are trying to remove
records from tables in an Access database?

Disk storage is CHEAP! Even if a record was not updated, what will you do
if you need to look up historical information the day after you delete
records?

If you want to make a "snapshot" copy of the current state of your database,
make a backup copy using Windows Explorer.

Regards

Jeff Boyce
<Access MVP>

 

[Mr K Morris]

I have a database of my engineers there are 15 men each doing between 8 and
10 jobs a day about 50% of these jobs are new customers so the database is
getting very large and I am afraid that I may hit a maximum limit
I am using access xp and split the database customers(8800 files so
far ), engineers(20), and jobs(12000)

 

[Jeff Boyce]

I am not familiar with your use of the word "files". I do not know how much
information you are recording per engineer, per customer, per job. I don't
know how your data is structured.

Have you checked Access HELP for "specifications" -- you will find info
about max capacity.

Regards

Jeff Boyce
<Access MVP>

 

[Rick B]

Please fix your system time. It looks as though you are trying to make your
post appear above everyone elsee's.

"remove any files that..." What do you mean "files"?

To remove old records, you'd need to look at a date field in the record. If
you don't have one, then yo ucan't do it.

 

[Rick B]

Is your system clock counting backwards?

This post shows 3:10 on the 24th, but your previous one shows 4:00 on the
25th.

 

[Mr K Morris]

I want to tidy up a database and save and remove any files that has not been
updated over the last 3 years

how do I save files automatically to a old data file
how do I delete data from a database automatically
any help welcome
P.s.
I only doing this to stop the database getting to large