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

 

[strongm]

Presumably you are working through ADO?

Check out this knowledgebae article:

http://support.microsoft.com/support/kb/articles/Q246/9/05.ASP

 

[TNN]

Hi Strongm,
That knowledge article seems to apply when using the Shape command. I am NOT using the Shape command.

Yes, I am using ADO with the access 2000 Database. 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];

Any ideas?? Thanks.
TNN, Tom
TNPAYROLL@AOL.COM




TOM

http://WWW.TNPAYROLL@AOL.COM