Record locking bc of linked tables

Record locking bc of linked tables

Post by Gan Ming Tei » Fri, 20 Jul 2001 21:59:00



I am using SQL 2000 tables as a back-end and Acccess 97 as a front-end. I am
trying to insert certain data from a local table into the SQL linked table
using an SQL statement. This is causing record locks; I can't make changes
to the records that have been appended to the linked table using this query.
I can go into the SQL itself and change these records. I need major help!
Please help!
 
 
 

Record locking bc of linked tables

Post by Mary Chipma » Sat, 21 Jul 2001 00:43:42


You'll need to provide more details about how you are doing the
appends and how you are doing the updates that don't work.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

On Thu, 19 Jul 2001 20:59:00 +0800, "Gan Ming Teik"


>I am using SQL 2000 tables as a back-end and Acccess 97 as a front-end. I am
>trying to insert certain data from a local table into the SQL linked table
>using an SQL statement. This is causing record locks; I can't make changes
>to the records that have been appended to the linked table using this query.
>I can go into the SQL itself and change these records. I need major help!
>Please help!