Unanswered: Problem with forms and SQL linked tables
Current coding an MS Access front end to a database stored on a MS SQL Server using linked tables in access, I'm getting the age old "the record has been changed by another user while you were editing it" error but this seems to be in different than usual circumstances.
This message is only popping up after I re-update a table in the SQL linked table manager. All that has changed in the table is there are now a few more fields of varying data types. As soon as I have re-updated this, I get the error. Does anyone have any ideas?