title: Linked Access DB "record has been changed by another user"
body: <p>I'm maintaining a multiuser Access 2000 DB linked to an MSSQL2000 database, not written by me.</p>
  
  <p>The database design is very poor, so you'll have to bear with me.</p>
  
  <p>On the 'Customer' form there's a 'Customer_ID' field that by default needs to get the next available customer ID, but the user has the option of overriding this choice with an existing customer ID.</p>
  
  <p>Now, the Customer_ID field is not the PK of the Customer table. It's also not unique.</p>
  
  <p>If a customer calls twice to submit a job, the table will get two records, each with the same  customer information, and the same customer ID.</p>
  
  <p>If a user creates a new ticket, Access does a quick lookup for the next available customer ID and fills it in. But it doesn't save the record. Obviously a problem - two users editing have to keep track of each others' work so they don't dupe up a customer ID.</p>
  
  <p>So I want to modify the "new record" button so it saves the ticket right after creating a new one.</p>
  
  <p>Problem is, when I test the change, I get "This record has been changed by another user since you started editing it".</p>
  
  <p>Definitely no other users on the DB. The 'other user' was presumably my forced save.</p>
  
  <p>Any ideas?</p>