Utility to Remove old Records

tyman00 · Post by **tyman00** » Wed Jun 21, 2006 5:57 am

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 · Post by **davidyin** » Wed Jun 21, 2006 2:10 pm

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 · Post by **davidyin** » Wed Jun 21, 2006 2:21 pm

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 · Post by **tyman00** » Wed Jun 21, 2006 8:11 pm

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 · Post by **davidyin** » Thu Jun 22, 2006 10:29 am

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

tyman00 · Post by **tyman00** » Thu Jun 22, 2006 11:30 am

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

That's what backup's are for

AnthonyLopez · Post by **AnthonyLopez** » Mon Sep 10, 2018 12:27 pm

tyman00 wrote: Wed Jun 21, 2006 5:57 am 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.

I do utilize the Compact and Repair charge in MS Access, yet it is still up there. We have 50 individuals that are continually utilizing this board.

G2Soft.Net Support Forum

Utility to Remove old Records

Utility to Remove old Records

Re: Utility to Remove old Records