EAB1977
2010-04-23 12:36:19 UTC
Hi All,
I have created a database that stores information about gauges/items
within our company and tracks it's location, whether the item has
changed location, is in a repair state, being calibrated, on loan to a
different department, etc. When a user updates a serial number
(currently we have generic serial numbers and are putting the correct
serial numbers in it's place) the serial number changes and the data
is saved to the database.
My database has many relationships to keep the data integrety(sp) in
check. The problem I am having is that once the user has changed the
serial number, saves the data, and then goes into a existing repair,
the I get a error 92.
I wonder if someone has had this same experience and has found a
solution. I am using Access 2007 software with the program written in
Access 2003.
I have created a database that stores information about gauges/items
within our company and tracks it's location, whether the item has
changed location, is in a repair state, being calibrated, on loan to a
different department, etc. When a user updates a serial number
(currently we have generic serial numbers and are putting the correct
serial numbers in it's place) the serial number changes and the data
is saved to the database.
My database has many relationships to keep the data integrety(sp) in
check. The problem I am having is that once the user has changed the
serial number, saves the data, and then goes into a existing repair,
the I get a error 92.
I wonder if someone has had this same experience and has found a
solution. I am using Access 2007 software with the program written in
Access 2003.