Iam new to using Access & SQL server. We use Microsoft Access as front end and SQL server as backend for data Access. I am trying to run a userdefined function(limit check) which takes 2 parameters and returns me a value.
I implemented this way: A subform on a main form connects to the Table. The first 2 columns takes the 2 parameters from the subform and 3 column (computed column specification which runs the userdefined function and gives me a value in 3 column) Iam returning
the 3 column value back to Access from. The primary key is on first 2 parameter columns. This worked fine when using 1 Access module. But In production when 5 Access modules try to access the same subform I get "write conflict error" This record
has been changed by user since you started editing it. If you save this 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.The 3 options that I have save record, drop changes,copy to clipboard.
Though the 2 records are different somehow sql is thinking that I am trying to modify the same record.
When I drop changes press Esc, go back and re run the check it is working fine. Is there any way to get around this problem? There is a way to directly call the function in Access but I
View Complete Post