Hello all,
I am trying to learn SQL. So I created a database in SQL and linked the tables to my Access database. I am having this error come up It is a write conflict error shown below in red. the Save Record button is disabled. I do not understand. I open the access database and try to edit a record. No one else has access to the database, so it cannot be someone else editing it. I can go into SSMS and edit the record and I am okay in both SQL and Access. But that is not how I imagined editing records.
My research states to put a TimeStamp field in the SQL, and then another site said a timestamp field will cause the issue. All of this works in my current production database with the local tables. So it seems like the connection to SQL maybe messed up. But the edits in SQL show up immediately in Access.
I have looked at something called dsn-less connections and that seems like it could work, but why does the write conflict even happen. why should I try that if a simple connection should work?
Thank You for listening to my frustrated rattling. But if anyone has any thoughts, please let me know.
Thank You
Jim Wagner
This record has been changed another user since you started editing it. If you save the record, you will overwrite the changes the other user made.
Copying the changes to the clipboard will let you look at the values the other user entered, and then paste you changes back in if you decide to make changes.
Posted by: luvmymelody@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar