By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,706 Members | 1,105 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,706 IT Pros & Developers. It's quick & easy.

Access 2010 fails where 2007 worked

P: n/a
In Access 2010 I get a Write Conflict error - "This record
has been changed by another user..."
In Access 2007 this Code is working - why?
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_BeforeUpdate(Cancel As Integer)
  2. Dim dbs As DAO.Database, rst As DAO.Recordset, strCriteria As Variant
  3.  
  4. Set dbs = CurrentDb
  5.        Set rst = dbs.OpenRecordset("Artikel", dbOpenDynaset)
  6.        strCriteria = "[Artikel-Nr] =" & Me.[Artikel-Nr]
  7.        rst.FindFirst (strCriteria)
  8.  
  9. If Not Me.NewRecord Then
  10.         rst.Edit
  11.         rst("Lagerbestand") = rst("Lagerbestand") + anzdif
  12.         rst.Update
  13. rst.Close
  14.         Set rst = Nothing
  15.         Set dbs = Nothing
Nov 10 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.