record has been changed by another user

  • Thread starter Thread starter GA
  • Start date Start date
G

GA

Any help would be gratefully received.

In an mdb front end to a sqlserver backend, I have a form with a tab
control containing a number of tabs some of which have sub forms on them.
It worked fine until recently and now when trying to update any data I get
"This record has been changed by another user since you started editing
it."

I have no problems changing the data directly in either the sqltable or
the sqlview to which the mdb linked table points.

I get the error if I try to change any data the Access linked table which
indicates that it's not the form that is at fault.

I've deleted the linked table and re-linked it. I use a composite of
'payroll_number' and 'surname' to create the key when linking and the
Access table shows as being updatable.

I'm at a loss now so can anybody suggest what might be wrong please.
 
...aarrrgghhhh - I knew this all along but the brain cells are leaking. In
case it's of interest to anyone else -

Allowing Null values in a bit (Yes/No) field in sql causes problems to an
Access front end.

I recently added several bit fields to my sql table and forgot!!

Updated all the relevant fields to false and then changed the sql table
design and everything works again 8^)
GA
Any help would be gratefully received.
Click to expand...
In an mdb front end to a sqlserver backend, I have a form with a tab
control containing a number of tabs some of which have sub forms on them.
It worked fine until recently and now when trying to update any data I get
"This record has been changed by another user since you started editing
it."
Click to expand...
I have no problems changing the data directly in either the sqltable or
the sqlview to which the mdb linked table points.
Click to expand...
I get the error if I try to change any data the Access linked table which
indicates that it's not the form that is at fault.
Click to expand...
 
Back
Top