RUN-TIME ERROR -2147467259

[TNN]

I am trying to update a recordset and am getting a Run-Time error -2147467259 "INSUFFICIENT KEY COLUMN INFORMATION FOR UPDATING OR REFRESHING".

I am updating the recordset by using Bookmarks to move to a different record. The Database is access 2000.

This is working good in a different module but can't make work in this one.

Can anyone give me a clue on that error message??

Thank You,
TNN, Tom
TNPAYROLL@AOL.COM

TOM

http://WWW.TNPAYROLL@AOL.COM

 

[JNC73]

Hi TNN,

I believe that your table has a multi column primary key and you have to use the complete key to update data in your table.

Hope this helps

JNC73

 

[TNN]

Hi JNC73,
Thank You for your input.

I had no keys assigned to either table but had multiple indexes assigned. I removed all the indexes but still get the same error message. My SQL stored procedure is as follows:

DisplayF2 PARAMETERS [Employee_Number] IEEEDouble;
SELECT DEDNAME, BASSDEDS.DEDNO, DEPT, TYPE, AMOUNT, MTD_AMT, QTD_AMT, YTD_AMT, EMPNO
FROM BASSDEDS INNER JOIN BASSDDED ON BASSDEDS.DEDNO = BASSDDED.DEDNO
WHERE EMPNO = [Employee_Number];

I am using ADO with my access 2000 Database.

Anyone??
Thank You,
TNN, Tom
TNPAYROLL@AOL.COM


TOM

http://WWW.TNPAYROLL@AOL.COM