RogerCooper
Registered User.
- Local time
- Today, 00:25
- Joined
- Jul 30, 2014
- Messages
- 288
Last night, I needed to rebuild my database by creating a new database and copying all objects into the new database. I am now receiving the "This record has been changed by another user since you starting editing it" error when I edit a specific table that is linked to SQL Server.
1. If I go back into the old database, I can edit the table.
2. If I create a Select query, I can make changes using the recordset.
3. The SQL table does contain bit fields, but they have default values set.
4. If I copy and paste the table from the old database into the new database, it does not work.
5. I have tried deleting the link and recreating it.
I had to set some options in the new database, but I don't see that any would affect editing SQL tables. I can work around this issue, but I would still like to know what is causing the problem. Any ideas?
1. If I go back into the old database, I can edit the table.
2. If I create a Select query, I can make changes using the recordset.
3. The SQL table does contain bit fields, but they have default values set.
4. If I copy and paste the table from the old database into the new database, it does not work.
5. I have tried deleting the link and recreating it.
I had to set some options in the new database, but I don't see that any would affect editing SQL tables. I can work around this issue, but I would still like to know what is causing the problem. Any ideas?