When attempting to update or delete data in a
linked DB2 table from within MS Access 97 (or
2000), Access returns a message box saying “no current record” even though the record is selected.
Records inserted by a batch process (we’re running OS/390) cannot be updated or deleted in Access. If data is inserted using Access, it can be updated/deleted from either Access or batch.
Our DBA has done some testing and seems to think it is related to the timestamp column which is 26 bytes textin DB2 apps. and is type “timestamp” in Access. We have no idea why this might be happening. Anybody have any clues or solutions for this?
