Pb : ACC97 and SQL6.5 locked tables

Pb : ACC97 and SQL6.5 locked tables

Post by Jerome Arnau » Tue, 12 May 1998 04:00:00

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 ?



Pb : ACC97 and SQL6.5 locked tables

Post by Bob Pfeif » Tue, 12 May 1998 04:00:00

You can get the "changed by another user" error with linked tables in Access
if there is no timestamp column defined in the table.  The timestamp is used
for row versioning to determine if the row was changed by another process
since it was fetched.  If there is no timestamp, row versioning is
accomplished by comparing the row data and if there are imprecise datatypes
like float, this comparison always produces a difference and you get the
error.  I don't know why Delphi and MS Query don't have this problem.

Bob Pfeiff, MCSD
Spectrum Technology Group, Inc.


1. migrating a acc97 database to a new dbase model in acc97 using a vb client

My subject pretty much says it all.  I am migrating a Access97 mdb to a new
Access97 database with a enhanced design.  What would be the best approach
for transferring the old database to the new design?
Aditionally would there be any advantage to moving the db to A2K?  I was
planning on using ADO but because this application will be deployed on win
95/98/NT/2K it would be easier to deploy (won't need dcom95/dcom98/IE5
etc.).  This will mainly used by a maximum of four concurrent users in a
client server environment.  Please post commens and advice.


2. Storing yearless dates.

3. Help needed: Acc97 SQL60; locking problem

4. Connecting Oracle 8i from NT Client without ODBC

5. Phantom lock on Acc97 database stopping compact routine

6. moving sql7 sys cat ldf

7. Table is locked, workstation coughs, table stays locked.

8. sql join problem

9. linking to acc97 tables

10. Trans Acc97 to SQL2K -- Updating Dimension Table

11. Acc97: #Deleted - linking tables with ODBC

12. acc97: How to create a report with with data from two NOT ralated tables

13. lock: pb with resource timeout