I have an Access 2000 front-end with a SQL Server 2000 back-end. My tables are linked using ODBC.
On one of my forms, I give users the option to delete a record. The user selects from a list box. The list box has an After_Update event that does the following
Me.lstAkHandle.Requery
Me.Form.Requery
Me.Form.Refresh
Me.RecordsetClone.FindFirst "[AKNO] = '" & Me![lstAkHandle] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
After the record is deleted, a dialog box pops up saying
Write Conflict: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes. (3 buttons: Save Record(grayed out), Copy to Clipboard, Drop changes)
I am the only user in the database so I know no one else has made any other changes.
I have found other articles that have suggested setting defaults for my bit type fields - I have done this (defaulted them all to 0) and I am still getting this error.
Any help would be appreciated! I have been fighting this for days (-:
On one of my forms, I give users the option to delete a record. The user selects from a list box. The list box has an After_Update event that does the following
Me.lstAkHandle.Requery
Me.Form.Requery
Me.Form.Refresh
Me.RecordsetClone.FindFirst "[AKNO] = '" & Me![lstAkHandle] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
After the record is deleted, a dialog box pops up saying
Write Conflict: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes. (3 buttons: Save Record(grayed out), Copy to Clipboard, Drop changes)
I am the only user in the database so I know no one else has made any other changes.
I have found other articles that have suggested setting defaults for my bit type fields - I have done this (defaulted them all to 0) and I am still getting this error.
Any help would be appreciated! I have been fighting this for days (-: