ODBC linked records show as #Deleted

  • Thread starter Thread starter Dan Loughridge
  • Start date Start date
D

Dan Loughridge

My Access 2000 database has ODBC links to tables in an
Oracle 8i database. One of these tables shows some
records as deleted (all fields contain #Deleted), but
others are fine. The records are all present in Oracle,
and display ok from an Access '97 database connected to
the same Oracle table.

The table in question has the following structure:
field_1 - varchar2(20), key
field_2 - varchar2(20), key
field_3 - date
field_4 - char(1)

Field_2 contains encrypted text based on the ISO
character set, so there are many odd characters.

Is there a registry setting or some other configuration
setting that will allow Access 2000 to display all the
records in my table?

Thanks,
Dan
 
Hi Dan,

Thanks for your post. If I understand correctly that your access 2000
database has ODBC linking to Tables in an Oracle 8i database. One of your
tables shows some records as deleted (all fields contain #Deleted), but
others are fine.

1. Please try to apply the latest version of MDAC. To download the latest
version of MDAC, go to the Universal Data Access Web Site located at the
following web address:

Microsoft Data Access Components (MDAC) 2.8
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-
b037-185d0506396c&DisplayLang=en

2. Delete the existing view or table link and recreate, specifying a unique
index with a data type Access can map (such as a Date/Time stamp, Long
Integer, or Integer), ensuring that the specified index contains only
unique data.

3. Please check the following points on your side.
a. Using Pass-Through query
b. Don't use fixed-length text field on your unique Index
c. Make sure there is no null value in your primary key

I also found the following article for your reference
ACC: "#Deleted" Errors with Linked ODBC Tables
http://support.microsoft.com/?id=128809

243467 ACC2000: #Deleted Error with a Linked Oracle Table That Has a Numeric
http://support.microsoft.com/?id=243467

104977 ACC: Conversion of ORACLE Data Types to Microsoft Access
http://support.microsoft.com/?id=104977

ACC2000: Access Displays #DELETED When You Insert Data with the Same Value
into a Non-Unique Key Column of a Remote Table
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
80/SUPPORT/KB/ARTICLES/Q257/4/87.asp&NoWebContent=1

Thanks for posting in community.

Thanks & Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Hi Dan,

How is the issue going on your side? Let us know if you need further
assistance on this issue.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Back
Top