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

Error 3020 Update or CancelUpdate without AddNew or Edit (Form Error)

P: n/a
Access 2002 MDB -> SQL Server 2000 - ODBC Linked tables.

B4 we start, this is not occurring in a recordset operation and yes I
googled, even found my own fix, which I already use
(http://tinyurl.com/2e8os) but in one particular form it's getting
worse, sometimes accompanied by a "Another user has modified the data"
or something or that the form's values have reverted back to their old
values before my workaround in the Form_Error event has fired. Also a
new error number with the same message but the number being in the
minus 2 billion region

All Validation code that was BeforeUpdate on controls has been moved
to AfterUpdate and ControlName=ControlName.OldValue put in place of
the Cancel=True and .Undo.

The only BeforeUpdate event now is the form itself, which it isn't
getting that far either. The form and controls have been recreated
with the code copied in to rule out form corruption. The underlying
query has been changed to a SQL view although I don't think the data
source has a baring on it as others have had the same problem using
Jet databases.

I've also ruled out
http://support.microsoft.com/default...b;en-us;179616 as a
possible cause as although I have some timer code on my main menu
form, no updates are done, I even got the problem with the timers
turned off as well.

Can anyone shed any new light on this?

--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.