Microsoft KB Archive/243467

= ACC2000: #Deleted Error with a Linked Oracle Table That Has a Numeric Field That Contains a Decimal Value =

Article ID: 243467

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q243467



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you link an Oracle table that has a decimal value in a field that is defined just as a number to a Microsoft Access 2000 database, the row displays #Error.



RESOLUTION
To resolve this issue, obtain the latest Microsoft Jet 4.0 service pack that contains an updated version of the Microsoft Jet 4.0 database engine.

For additional information about how to obtain the latest version of the Jet 4.0 database engine, click the article number below to view the article in the Microsoft Knowledge Base:

239114 How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce Behavior
 On a clean computer, install Microsoft Windows 95, Microsoft Windows 98, or Microsoft Windows NT Service Pack 3. Install Microsoft Office 2000. Install the Oracle 8.05 Client. Click Start, point to Oracle for Windows 95, and then click Net Easy Config. Click Add New Service. Enter the server name, and then click Next.</li> Click TCP/IP, enter the server name as the Host Name, and then click Next.</li> Enter the appropriate Database SID, and then click Next. Click Next again, and then click Finish.</li> Click Start, point to Programs, point to Oracle for Windows 95, and then click SQL Plus 8.0. Enter the appropriate logon information, and then click OK.</li>  Enter the following command to create a table: Create table TestError (F1 Number); This returns "Table created." </li>  Insert a record into the table by entering the following: Insert into TestError Values(12.34); This returns "1 row created." </li> Enter "Exit" to close SQL Plus 8.0.</li> Using the ODBC Administrator, create a new DSN for the Oracle database that uses the Microsoft ODBC for Oracle driver.</li> Start Microsoft Access 2000, and then create a new database.</li> On the File menu, point to Get External Data, and then click Link Tables.</li> In the Link dialog box, change the Files of type box to ODBC Databases.</li> In the Select Data Source dialog box, click Machine Data Source.</li> Select the DSN that you created in step 12, and then click OK.</li> Enter the appropriate logon information, and then click OK.</li> Find and select the table that you created in step 9, and then, click OK.</li> In the next dialog box, select the field that you created, and then click OK.</li> Open the table in Datasheet view.

Note that the value in the field is #Deleted.</li></ol>

<div class="references_section">