Record Edit Error Message

B

Baffee

I have a link from Access to an SQL Table. If I try to make any changes
directly in the table in Access I get the following Write Conflict
message:"This record has been changed by another user since you started
editing it." There are options to either Copy to the Clipboard or Drop the
changes.

I am the only user in the database. The only way I can make changes or
delete records it to go into enterprise manager and do it in the SQL table.

Is thier a way to fix this problem??

Thanks!
 
V

Van T. Dinh

Do you have a TimeStamp Field in the SQL Table?

If you don't, add a TimeStamp Field in the SQL Table. In fact, I have a
TimeStamp Field in *every* SQL Table that I link to Access.
 
Top