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.

PieterLinden via

Do you have Cascading Updates turned on? If not, you're going to orphan all
the child records of whatever item you're updating.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question 7
Access question 3
PDS Questions 0
MDE questions 4
Simple Question 0
Raid question 14
Data question 1
acc97-->acc2000 question 2