"#deleted" values in linked (ODBC) Oracle tables

[Rookie]

I'm trying unsuccessfully to link Oracle tables to Access (2003). When
a linked table is opened each field contains a "#deleted" value. Each
Oracle table has a primary key constraint.

I've googled for this and found only that access needs each row to be
unique.

 

[Pieter Wijnen]

A long time since I saw that one
It has to do with The Driver beeing Added to %WinDir%\ODBC.ini when you
create the DSN as far as I recall
Delete the ODBC.ini entries for the Oracle ODBC driver
Also try to obtain the newest possible ODBC driver for your version from
Oracle (http://otn.oracle.com) & use that, make sure everybody uses the same
driver version

HTH

Pieter

 

[peter.rooke.comp.groups]

Thank You...

A long time since I saw that one
It has to do with The Driver beeing Added to %WinDir%\ODBC.ini when you
create the DSN as far as I recall
Delete the ODBC.ini entries for the Oracle ODBC driver
Also try to obtain the newest possible ODBC driver for your version from
Oracle (http://otn.oracle.com) & use that, make sure everybody uses the same
driver version

HTH

Pieter



--------------------------------------------------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4388 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!

 

[aaron.kempf]

Oracle is SHIT.
MDB is SHIT.

Learn Access Data Projects... use a freeware MS SQL Server database
SERVER.

-Aaron