We just recently upgraded our SQL Server 2000 to the latest service packs. I connect to my SQL tables via an ODBC connect using Access XP.
When I am in Access try to update a recently added record in two of my main tables I get a write conflict error that says that the record has been updated by another user since I started editing it. It will not let me update that record. BUT...
If I try and update any records that were previously entered in the table (before the updates), the records update fine.
I can also update the record if I go into SQL Enterprise Manager. I am wondering if it is a problem with ODBC?
I know for a fact that I am the only person in this database, so I do not understand what is going on. I really hope that someone can help me out. I am at a loss. Thanks very much!!
When I am in Access try to update a recently added record in two of my main tables I get a write conflict error that says that the record has been updated by another user since I started editing it. It will not let me update that record. BUT...
If I try and update any records that were previously entered in the table (before the updates), the records update fine.
I can also update the record if I go into SQL Enterprise Manager. I am wondering if it is a problem with ODBC?
I know for a fact that I am the only person in this database, so I do not understand what is going on. I really hope that someone can help me out. I am at a loss. Thanks very much!!
