I am getting an error similar to the error where me and another user are
modifying the same record. But there was noone else modifying the record.
Below is the code where the error came from:
DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, A_SELECTRECORD_V2, ,
A_MENU_VER20 -->(this is where the error pops out...)
DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, A_DELETE_V2, , A_MENU_VER20
DoCmd.GoToControl "Date Received"
A little history about the application:
a. originally written in Access 97, but I have modified the application
several times until its current version which is Access 2003
b. the current version of our access based application runs in MS Access
as the front-end application and the back-end is in SQL Server 2005
More information about the problem:
a. the current version of the MS Access-based front-end worked fine
until we upgraded our SQL Server service pack from 1 to 2
b. the early errors that came out after the server patch upgrade were
from embedded queries performing updates, inserts, and deletes
c. I solved the above problems by calling server stored procedures
c. now the confusing error is this latest error where at the
DoCmd.DoMenuItem line it caused a referential integrity check message
d. i tried to update the DoMenuItem line to use the updated programming
code but I still got the same error
Let me know if you guys/gals have some feedbackc.
Thanks,
Be
