Utility to Remove old Records

[tyman00]

Our database is getting pretty large. Is there a way we could write a script that would go and check to see if that record is being used anymore. It would have to check to see if the record is currently being displayed by default.asp or if it will be used for a future event.

Would this create an issue with your reports? We don't use them, but I don't want to you to create a utility that would break the reports either.

[davidyin]

The tool to backup and compact your database file.
Save the attachement into your main folder.
Run it.

The backup up file will be saved in your dbs folder and the database file will be compacted.

You need the NTFS write permission and FSO support.

[davidyin]

The file size has no limit basicly.
The tool I provided is to used to compact it and backup it.
I think the efficiency of program will be better if you compact your database.

Anyway, I will make a better database tool in the next version.

[tyman00]

I do use the Compact and Repair command in MS Access, but it is still up there. We have 50 people that are constantly using this board. It adds up quickly.

[davidyin]

How big about the database file?
Do you fell the speed slow when open the page?

[tyman00]

No I don't. But I am looking into the future. Especially since we are probalby going to increase our employee numbers in the near future so we will have even more records.

I suppose I could go and manually delete some of the records and hope I don't break anything  :lol: