Hi All -
I have a client for whom I developed an Access 2000 database. The
database is split into 2 files - front-end (forms, queries, reports),
and back-end (tables). An .mde file has been made for the front end
file.
Recently, they have been noticing some "problems" with the system.
Basically this system creates invoices for their customers. They have
been noticing that some of the invoices are now "wrong", specifically
that different (and incorrect) items were showing up on invoices, but
the totals are always correct.
This led me think that the Product Master records were being changed
(even though they assured me that products would _never_ change).
Here is the basic table structure:
PRODUCTS:
product_id - autonumber
category_id - FK to Categories table
product_code - 4 digit number that means something to them
product_desc - description of the product
....
other insignificant fields
To research the problem, I created a new database, and imported (into
2 separate tables, of course) the Products table from both a backup
copy of the database and the current database. I ran a query that
joined the 2 tables on product_id and looked for product_desc not
being equal. I found 10 records.
It looks to me that someone changed the descriptions on the records.
Oddly enough, the "new" descriptions are exactly those of some other
existing products. Of course, the client swears that there is no way
anyone edited any of the Product Master records. Only the
product_code and product_desc have changed on these 10 records.
I scanned all VBA code in the front-end for SQL Update statements.
There are no Update statements that update the Products table.
I've been on here researching corruption, and people talk about all
the errors they get, and how the database won't Compact/Repair. I am
not having any of those issues at all. I regularly Compact/Repair, as
well as back up the databases.
One interesting note: There is only one .mde, and it is located on
the server. They have people in the office accessing it from desktop
shortcuts using mapped network drives. The best part is, they have 4
to 6 people at a time "out in the field" accessing the .mde on the
server via Terminal Server. None of this was my recommendation.
This is only my 2nd or 3rd post, so I hope I have provided enough
information to help you all: My question is this - Is there any way
this could database corruption? Even the slightest possiblility?
Honestly, to me it looks like someone edited records. It is possible
to do that through one of the forms.
I don't want to get in the habit of manually editing production data.
Its annoying. I can't think of any Access malfunction that would edit
existing records yet not cause obvious symptoms of corruption, but I
guess that is why I am posting this.
Thank you in advance for any help -
Doug