I have been trying to migrate data from an Access database to SQL Server 2000. I have successfully imported the data into SQL and have created an odbc connection to the SQL database. I linked to the tables from access (still using it as front end) and everything appears normal at first. The problem is when I try to edit a record that was created after the data migration. I get a message stating that the record was modified by another user since it was opened, and it won't save the record changes that I make. Records that were imported into SQL from access work normally (I can edit them)
I would appreciate any help I can get.
Thanks--
I would appreciate any help I can get.
Thanks--