I'm converting an Access database to use MSSQL as the backend (connecting via ODBC), keeping the forms in Access for the users. I've been able to connect to the tables with no problem, view existing entries and enter new records. I can update information in records that were entered in the Access version (and transferred into MSSQL).
I receive a Write Conflict if I try to update and entry that was made in the form after converting it to use the MSSQL table. This occurs if I add a record, leave the record and come right back to change something. It also occurs on records that I added yesterday.
The conflict basically states that the record has been changed by another user since I started editing it (no one else is using the database). I can either copy to clipboard (which generate another error) or drop the changes.
Any help is greatly appreciated.
I receive a Write Conflict if I try to update and entry that was made in the form after converting it to use the MSSQL table. This occurs if I add a record, leave the record and come right back to change something. It also occurs on records that I added yesterday.
The conflict basically states that the record has been changed by another user since I started editing it (no one else is using the database). I can either copy to clipboard (which generate another error) or drop the changes.
Any help is greatly appreciated.
