E
Elvis
My database is multi-user and I have done the split. Before I did the split
if I had a form up with a single record of data and then before I could
commit it another user brought up the same record and changed it...I got a
nice error message from access with a reasonable error number. I'm using all
DAO code..no ADO anywhere.
Note that I am not directly changing the field but using two other unbound
fields which are used to calculate the new field value when the user clicks a
button.
With database now split the same scenario brings up a simple error message
"the data has been changed". with a error message of -2147352567..ugly.
Interestingly if I make the recordset readonly (snapshot) and then attempt to
edit the record I get the error message "this recordset is not updatable",
with the SAME error number. Has the split gone wrong or is there a property
somewhere I need to update?
I am using Office 2000 SR-1
Thanks.
Elvis.
if I had a form up with a single record of data and then before I could
commit it another user brought up the same record and changed it...I got a
nice error message from access with a reasonable error number. I'm using all
DAO code..no ADO anywhere.
Note that I am not directly changing the field but using two other unbound
fields which are used to calculate the new field value when the user clicks a
button.
With database now split the same scenario brings up a simple error message
"the data has been changed". with a error message of -2147352567..ugly.
Interestingly if I make the recordset readonly (snapshot) and then attempt to
edit the record I get the error message "this recordset is not updatable",
with the SAME error number. Has the split gone wrong or is there a property
somewhere I need to update?
I am using Office 2000 SR-1
Thanks.
Elvis.