My application has MS access front end and SQLserver 7.0 backend connected through ODBC. When a user tries to enter something or updates already existing fields,it gives the Write conflict message.It says Other user has changed the record, if you save it it will over write the changes made by the user. I want to overwrite but the save button is disabled on the form. I donot know whether this is a SQL server problem or MSACCESS or ODBC thing.
Thanks
Bharat