Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jun 2003
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Save in Access (Access XP)

    I have an access application that looks at a SQL Database.

    I will try to explain the problem but you may need more information so if that's the case I apologise now.

    The database is an asset management system. You search for asset from a search page, this opens the main assets form (which is based on the assets table). This form is made up of a series of sub forms dependant on what type of asset the item is. There is also links to other forms on this page. One of these links is to the Invoices window which is based on the Invoices table. On the main assets form there is a total Invoice Cost field which is the total sum of all invoice amounts in the invoices table. You can edit an invoice amount using a shortcut to the invoices window from the assets from here you can add an invoice or change an amount. There is a total invoice amount on this window to show the total spend for this item. When this window closes it updates the total invoice cost field on the assets form.

    If you then close the assets form it comes up with the following error message :

    Write Conflict

    This record has been changed by another user since you started editing it. . . . . . etc

    copy to clipboard, drop changes.

    I thought that it was because maybe the total invoice cost was being updated but I can't seem to figure out how to rectify the issue.

    Can anyone give me some advice as to where to look next? If you need clarification on anything please let me know.

    Many thanks

    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Save in Access (Access XP)

    If the total invoice cost field being updated by a trigger or stored procedure when you edit the Invoices table, that's what is causing your conflict. Try saving the current record in the asset form before you follow the link to the invoices form.
    Charlotte

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,613
    Thanks
    3
    Thanked 58 Times in 58 Posts

    Re: Save in Access (Access XP)

    I presume you are using ODBC to link to the SQL Server database. If that's the case, there could be several possibilities in terms of what is actually going on behind the scenes. We see this kind of thing fairly frequently when there are triggers involved - and that could well be the way that the total invoice value is being calculated. There should be an error number associated with the message - that will tell us if it's coming from ODBC, or whether it's actually an Access message. Do you know if the total invoice amount is carried in the main invoice record, or is it being calculated on the fly?

    Such problems can be challenging, but there is usually a solution. In this case we need more detail to try to help.
    Wendell

  4. #4
    Star Lounger
    Join Date
    Jun 2003
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Save in Access (Access XP)

    Hi thanks for the help, I changed the invoices form to update the table itself and it's not coming up with the error message.

    Many thanks for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •