A
Annelie
I used an existing database, deleted most unused items, created my own
tables for my farm workers time card program and calculations of the hours
worked and payment due them. I update this into a year to date table which
started in January of this year. I used the old database mainly to able to
re-use existing form and reports.
It works fine, be while the original database that I copied from has about
25 meg but is holding much more data and horrendous number queries and
reports and queries, it also stores data per jobs, per Employees, per
account no, going back to November of 2002. This database is split front
and back end. I am doing an incredible amount of calculations in there. We
import 4 tables from access to the able to do job costing, billing, payroll
reports, and combination of both.
So here I am with this rinky dinky little database which shows 115 megs and
there is not much information in it. I recreated this database by manually
inputting figures from my spreadsheets starting with January 1, 2004,
manually re-inputting the date and time and updated each week to a Year to
date Table.It was a great test, with only 3 contract workers only. I used
the example on Allen Browne's website on how total calculate time and it
works.
Are those time calculation taking up all this room? When I update each week
to a year to date table, it drops data into that table, not calculations. So
why does this database continue to stay to big??.
The punch in time and punch out time from the time card, I am unitizing
converting hours to minutes and back.
What could be causing for this database to get to big, when I enter only 3
line? Until 3 weeks ago, we on had 3 permanent employees and keeps track of
the earning from the timecard and now we are adding farm piece workers. I am
literally using only 6 tables. and 4 queries for the database. Each week
then get updated to the year to date table with the results for the week
with append queries, but that date goes there already calculated, jut to be
able to pull year to date reports, which I have not even written.
When I copies the existing database for me to use for my own business used
only 25 meg between front end and back end.
What is going on?
Help Annelie
After compact and repair there is no change.
How do I get the size down. Compact and report does not do it.
Annelie
Thank heaven for spell-check
tables for my farm workers time card program and calculations of the hours
worked and payment due them. I update this into a year to date table which
started in January of this year. I used the old database mainly to able to
re-use existing form and reports.
It works fine, be while the original database that I copied from has about
25 meg but is holding much more data and horrendous number queries and
reports and queries, it also stores data per jobs, per Employees, per
account no, going back to November of 2002. This database is split front
and back end. I am doing an incredible amount of calculations in there. We
import 4 tables from access to the able to do job costing, billing, payroll
reports, and combination of both.
So here I am with this rinky dinky little database which shows 115 megs and
there is not much information in it. I recreated this database by manually
inputting figures from my spreadsheets starting with January 1, 2004,
manually re-inputting the date and time and updated each week to a Year to
date Table.It was a great test, with only 3 contract workers only. I used
the example on Allen Browne's website on how total calculate time and it
works.
Are those time calculation taking up all this room? When I update each week
to a year to date table, it drops data into that table, not calculations. So
why does this database continue to stay to big??.
The punch in time and punch out time from the time card, I am unitizing
converting hours to minutes and back.
What could be causing for this database to get to big, when I enter only 3
line? Until 3 weeks ago, we on had 3 permanent employees and keeps track of
the earning from the timecard and now we are adding farm piece workers. I am
literally using only 6 tables. and 4 queries for the database. Each week
then get updated to the year to date table with the results for the week
with append queries, but that date goes there already calculated, jut to be
able to pull year to date reports, which I have not even written.
When I copies the existing database for me to use for my own business used
only 25 meg between front end and back end.
What is going on?
Help Annelie
After compact and repair there is no change.
How do I get the size down. Compact and report does not do it.
Annelie
Thank heaven for spell-check