A97 ODBC to Oracle - All records "#Deleted"

[john471]

Hi All,

I'm having a strange problem happening here - I am using DSN / ODBC linked tables in AC97 to an oracle back end DB. Some tables open up fine, however for some other tables (on the same Oracle DB) when they open, AC97 displays all records as "#Deleted". They quite simply can't actually be deleted.

I also have ACXP on the same PC, so I converted a copy of the Access FE to XP, and using that converted copy, the offending tables open OK. Problem being almost all of my colleagues only have AC97 - so I really need it to work with that.

I searched the forum and read a (not so recent) post where a user described having a similar problem with DB2 tables, to which Pat Hartman suggested using the Linked Table Manager add-in to re-link the tables. I tried this on the AC97 DB, but the result is the same.

Can anyone help with this, or suggest anything worth trying?

NB: I am total novice with Oracle.

Thanks

John.

 

[Robert88]

Hi John,

Good Luck with it. I came across oracle connection once and like you not strong in it. Here is a web connection do not know if it will help?

http://www.orafaq.com/faq/how_does_one_attach_an_oracle_table_in_ms_access

http://www.databasejournal.com/features/oracle/article.php/3358411

HTH

Robert88