#Deleted when viewing linked tables from Oracle

[cstephens16]

Hello,

I am an Oracle DBA with little to no Access experience so please be kind.

As of yesterday a frequent user of Access 2003 (11.8166.8172) SP3 reported that all columns in all rows have the value #Deleted in a number of tables linked back to an Oracle database.

I am not experiencing this problem but I have Access 2007. It is not an option for this user to upgrade.

I've discovered several issues over the web with data type issues/ characterset issues but nothing seems to fix the problem. I've tried the Oracle supplied 11g and 10g ODBC drivers. I've tried the Microsoft supplied ODBC for Oracle drivers.

None of it seems to work and I am out of ideas. Can anyone suggest anything?

The problem wasn't noticed until yesterday so it can't have been happening for long. The problem is occuring in Oracle 10.2.0.3 and 10.2.0.1 databases. There has been no change in the Oracle environment.

There was a windows update recently but we tried uninstalling that and it didn't help.

any ideas?

 

[cstephens16]

we've also tried syncing the client characterset to the database characterset.

 

[cstephens16]

it seems that when i 'import' a table it displays fine. when i bring it in as a 'linked' table the #Deleted problem appears.

is this the proper forum for a question like this?

 

[cstephens16]

one last update before i wait for a response:

there is another user of Access 2003 that is able to view linked tables with no problem. we have been unable to find a difference in the setup.

 

[bluegno]

Did you confirm that the Access 2003 user who is NOT experiencing this problem is also on version (11.8166.8172) SP3? I have an Access ADP (SQL Server back end) thast is crashing on this version only.

 

[Ascaphus]

...As of yesterday a frequent user of Access 2003 (11.8166.8172) SP3 reported that all columns in all rows have the value #Deleted in a number of tables linked back to an Oracle database

I had a similar problem with MySQL linked via ODBC into an Access front end. When the primary key of the SQL table was of type BIGINT the #Deleted replaced all data in the table. No refresh or relink or reboot would affect the outcome. Redefining the column to 'Integer' took care of the problem. Maybe this applies to Oracle as well.

Matt