Question

Discussion in 'Access Conversion' started by EAB1977, Apr 23, 2010.

  1. EAB1977

    EAB1977 Guest

    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.
     
    EAB1977, Apr 23, 2010
    #1
    1. Advertisements

  2. Do you have Cascading Updates turned on? If not, you're going to orphan all
    the child records of whatever item you're updating.
     
    PieterLinden via AccessMonster.com, Apr 23, 2010
    #2
    1. Advertisements

  3. EAB1977

    EAB1977 Guest

    I do have the updates turned on.
     
    EAB1977, Apr 29, 2010
    #3
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.