Access entry problems

L

Lisa

I have a database that is set for reservations.

For some reason within the last couple of months we are double booking.
People have paid and the proper forms are filled out and they are reserved in
the system. The database is not set up for double booking. I am not sure
why this is happening. I am not sure if someone has deleted the previous
reservation and entered a new one and did not filll out a form for it or
what. Since it was paid for the reservation should not be deleted.

Could there be a glitch in the system? If so, how do I figure this out. OR
is there a way that we can track all entries, edits, deletions that are made.
...even if it does not track the computer tag but just the action and the
date? If possible, could we track previous usage or just future?

Thanks,
Lisa
 
R

Ruskin Hardie

Kind of difficult to answer this one, without knowing some of the details
about your database. Such as the bookings table. Does it have a primary non
duplicating key (such as booking or reservation id)? If so, it shouldn't be
possible to enter double bookings (based on the booking id). Maybe a repair
and compact might be needed.

How do you define a double booking? The same person staying for the same
period (which is possible, due to people having the same names), or the
booking id can duplicate?

Access has no inherent auditing capabilities (at least not 97 and below, not
sure about 2000 and above). The overhead could get extremely large (file
size, performance, etc). If you wanted to track changes, you would need to
do this yourself (which isn't hard to do, but requires vba knowledge). Also,
tracking changes would require a secure database if you want to record user
names against the changes (it's not difficult to do, but can be a little
daunting if you are not familiar with access security). You can track
changes, without enforcing security, but there is no way of knowing (or at
least, proving) who did those changes.
 
Top