Hello,
I could use some advice if at all possible. I have created a database that will report production information off a specific machine on the production floor.
Here are some my questions/concerns:
1. I have the potential to log 400k records a day. Most of them are bits 1 or 0, but that is a lot of records I think. Is there any way to automatically run a report at the end of or start of the day and then save the report in a different folder with a unique name for later use?
2. A very large portion of the data that is logged is 0 and I could stand to remove these from the database and this would cut down on size/number of records and speed reporting up.
Ok, now I am trying to improve it and I can reduce the amount of data logged but I am not sure how to bring it all together and that is what I am working on today/weekend. This would make some of the above a mute point but is there any advice to help on the two concerns above until I finish my improvements?
Thanks,
Hunter J.
Novice on Access
I could use some advice if at all possible. I have created a database that will report production information off a specific machine on the production floor.
Here are some my questions/concerns:
1. I have the potential to log 400k records a day. Most of them are bits 1 or 0, but that is a lot of records I think. Is there any way to automatically run a report at the end of or start of the day and then save the report in a different folder with a unique name for later use?
2. A very large portion of the data that is logged is 0 and I could stand to remove these from the database and this would cut down on size/number of records and speed reporting up.
Ok, now I am trying to improve it and I can reduce the amount of data logged but I am not sure how to bring it all together and that is what I am working on today/weekend. This would make some of the above a mute point but is there any advice to help on the two concerns above until I finish my improvements?
Thanks,
Hunter J.
Novice on Access