Access 97 changing data
From: doglover (anonymous_at_discussions.microsoft.com)
Date: 09/05/04
- Next message: rpw: "RE: Database of magazine articles"
- Previous message: David: "Re: Little boxes instead of spaces"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 4 Sep 2004 21:55:02 -0700
My database is changing data in fields with wrong
information and I am not exactly sure when this happens.
This is only occuring in one field and two tables are
involved.
table name field with problem
tblworkorders wrk_invno (primary key from tbl
invoice)
tblworkorders wrkno (primary key for this table)
tblinvoice invno(primary key for this table)
The wrk_invno is a one to many relationship (many on the
workorders side). When an invoice is created the
wrk_invno field is updated (automatically)with the invno.
The problem is that sometimes the system places the wrkno
in the wrk_invno field. I compact the database daily. I
have checked the code behind the form that creates the
invoice (invno) and see no errors. This did not start
happening until several weeks ago when we shut down our
server and disconnected because of a hurricane threat.
I thought about adding a field to the work order table
(tblworkorders) to track changes, to help isolate the
source and when the problem actually occurs. Any ideas??
- Next message: rpw: "RE: Database of magazine articles"
- Previous message: David: "Re: Little boxes instead of spaces"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
