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=Con trolName.OldVal ue 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.