#Deleted

[Guest]

I connected to an Oracle database and several of the tables I link to come
through fine.

2 of the major tables come through with a #Deleted in every single record.

For troubleshooting I've

1. Uninstalled/reinstalled
2. Updated the drivers
3. verified the tns names file was correct
4. noticed half of the tns name information I found on the web was listed
with SID or SERVICE_NAME, so I tried both versions.
5. tried uninstalling my service pack and adding them back one at a time to
see if that would work.
6 tried up dating my fonts
7. looked at all the options for MS Access
8. Looks at the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1

I did every thing the knowledge base said I should do

I can't figure this out.

Does anyone have any ideas?

Thanks

Shawn

 

[Guest]

Check that those tables have a primary key constraint enabled. Sometimes
there are problems with tables not having a PK especially when doing updates
and deletes.

If only one field has the #Deleted, check its datatype. Access might have
problems with the various LOBs and other fields supported by Oracle.

 

[Poprivet]

I connected to an Oracle database and several of the tables I link to
come through fine.

2 of the major tables come through with a #Deleted in every single
record.

For troubleshooting I've

1. Uninstalled/reinstalled
2. Updated the drivers
3. verified the tns names file was correct
4. noticed half of the tns name information I found on the web was
listed with SID or SERVICE_NAME, so I tried both versions.
5. tried uninstalling my service pack and adding them back one at a
time to see if that would work.
6 tried up dating my fonts
7. looked at all the options for MS Access
8. Looks at the
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1

I did every thing the knowledge base said I should do

I can't figure this out.

Does anyone have any ideas?

Thanks

Shawn

Doesn't the # indicate a deleted record awaiting the Compact command?
Compact and they might all be deleted.

 

[Phil H]

try relink the table. It may have changed since you link it last.

 

[Rick Brandt]

I connected to an Oracle database and several of the tables I link to
come through fine.

2 of the major tables come through with a #Deleted in every single
record.

For troubleshooting I've

1. Uninstalled/reinstalled
2. Updated the drivers
3. verified the tns names file was correct
4. noticed half of the tns name information I found on the web was
listed with SID or SERVICE_NAME, so I tried both versions.
5. tried uninstalling my service pack and adding them back one at a
time to see if that would work.
6 tried up dating my fonts
7. looked at all the options for MS Access
8. Looks at the
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1

I did every thing the knowledge base said I should do

I can't figure this out.

Does anyone have any ideas?

Thanks

Shawn

If you link to a table that has a primary key of a DataType that has no direct
match in Access that can happen. No real fix except to us a passthrough query
instead of a link for looking at data and use passthrough queries and/or Stored
Procedures for edits.

Unless of course you are in a position to change that PK or its DataType.