I am developing an application on SQL Server with an ACC97 client. I
work on attached tables. Sometimes, some records become locked under
ACC97. All action queries work, but when I try to update or delete a
record from a table (and not from a query) i get a message from Access
saying that the record is locked or has been changed by another user.
I did a few tries on the locked records :
- no problem with ms-query
- no problem when I connect the table from Delphi 3.0 with the same ODBC
- PROBLEM when connected through Jet3.5 from VB5.
- SQL Server manipulates the record normally.
Does anyone had this problem before ?
What can I do to avoid it ?