Access 2000 to RDB query returns #DELETED results - HELP!!!

[gerrya]

I have an Access 2000 database with a number of linked tables in an Oracle RDB database. There is one linked table where, for a simple SELECT query, it returns '#DELETED' in all the fields. I can get data from all of the other linked tables.

I have tried both Oracle RDB v2 and version 3 drivers with the same results. I have also updated the Microsoft Jet engine on the off-chance that this may work.

This table is pivotal for the application I'm building. I would appreciate any ideas that you may have on what causes this and how I could fix it.

Thanking you in advance.

 

[cmmrfrds]

Do you have a unique key identified for the table? Does the Oracle table have a unique index?

 

[jurgen]

Try using a before insert trigger with a sequence that gives you the primary key and use that one.

The problems is ODBC that loses the link between your record and the primary key, but is inserted correctly in the db