L
Logo
We have a database at work where 5 managers enter data. Each entry is
automatically given an id # which is the primary key for the table. After
each mgr has finished entering their data, a report is printed of the
accounts in their region. This report is then used to verify numbers
reported at each account. So we have 5 reports printed on paper of our 5
regions. All is good.
Now its 9 days later, and we are using the reports to double check hours vs
our payroll company for our two week pay period (this was the first week of
the pay period).
Instead of going to my manager's office to retrieve the printed reports I
re-run them again and just use my computer display to double check that the
hours are correct we are sending to payroll. I find that we are missing one
complete region that we had confirmed 9 days earlier. I opened the table to
see if maybe it was "hiding" somewhere but there is no data whatsoever for
that region for that week.
Upon studying the printed reports, I see that id #'s for records in the
missing region have been assigned to records scattered about the other 4
regions! The missing region was probably printed maybe an hour before the
others.
How can this happen? I'm looking at physical printed proof that Access has
assigned a unique id # to 2 different records, for all the records of one
region, about 40-50 records in all.
We've used this database for a year with no problems whatsoever...
automatically given an id # which is the primary key for the table. After
each mgr has finished entering their data, a report is printed of the
accounts in their region. This report is then used to verify numbers
reported at each account. So we have 5 reports printed on paper of our 5
regions. All is good.
Now its 9 days later, and we are using the reports to double check hours vs
our payroll company for our two week pay period (this was the first week of
the pay period).
Instead of going to my manager's office to retrieve the printed reports I
re-run them again and just use my computer display to double check that the
hours are correct we are sending to payroll. I find that we are missing one
complete region that we had confirmed 9 days earlier. I opened the table to
see if maybe it was "hiding" somewhere but there is no data whatsoever for
that region for that week.
Upon studying the printed reports, I see that id #'s for records in the
missing region have been assigned to records scattered about the other 4
regions! The missing region was probably printed maybe an hour before the
others.
How can this happen? I'm looking at physical printed proof that Access has
assigned a unique id # to 2 different records, for all the records of one
region, about 40-50 records in all.
We've used this database for a year with no problems whatsoever...