Access 97 ODBC to SQL 6.5/Sp4 error 3156 
Author Message
 Access 97 ODBC to SQL 6.5/Sp4 error 3156

We've been having intermittent problems with our Access 97 ODBC connection
to SQL Server during certain operations, specifically a delete.  We get the
following error: "3156 - ODBC--delete on a linked table

In my Access 97 code, I'm executing the line of code:

DoCmd.RunSQL "DELETE FROM EDI_ShipmentsProcessedTemp"

The script to create the "EDI_ShipmentsProcessedTemp" table is:

CREATE TABLE dbo.EDI_ShipmentsProcTemp (
 AR_IVC_NO varchar (6) NOT NULL ,
 LN_NO int NOT NULL ,
 BatchID int NULL ,
 CONSTRAINT EDI_ShipmentsProcTemp_PK PRIMARY KEY  NONCLUSTERED
 (
  AR_IVC_NO,
  LN_NO
 )
)

If I go into the linked table manually, then select all the records and
press the DELETE button, I can delete them.

-Our SQL Server 6.5 has SP4 installed.
-Our ODBC driver on the client machine is version 2.65.0252 using named
SQLSVR32.DLL dated 6/16/97.

Any help is greatly appreciated!

Jeremy T. Goemaat
SteelWorks, Inc. 800-383-7414 X 234



Sun, 21 Jan 2001 03:00:00 GMT
 Access 97 ODBC to SQL 6.5/Sp4 error 3156

Jeremy,

When you linked the table did you specify AR_IVC_NO and LN_NO as a key to
Access?  You need that for delete access.  Is there any other users using
the table when you try to delete records from it?

Grant



Mon, 22 Jan 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Cannot access SQL Server 6.5 SP4 databases via Access 97

2. ODBC Error Treatment after upsizing Access 97 to MS SQL 6.5

3. ODBC Error SQL 6.5/Access 97

4. Linked Table between SQL 6.5 and Access 2.0 or Access 97 through ODBC

5. ODBC timeout when connecting from ACCESS 97 to SQL Server 6.5 (heavy loaded server)

6. ODBC on SQL 6.5 and Access 97 remote clients

7. Use link ODBC to replicate tables SQL 6.5 to database Access 97

8. Connecting to SQL Server 6.5 with MS Access 97 via ODBC

9. access 97 -> sql server 6.5 via odbc

10. Connecting to MS SQL Server 6.5 via MS Access 97 and ODBC

11. Lower performance for non-dbo users (SQL 6.5 SP4, NT 4.0 SP4, Access 2.0 client)

12. MS ACCESS 97/SQL server 6.5: deadlock problems when accessing server tables


 
Powered by phpBB® Forum Software