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

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.

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:

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

1. On a clean computer, install Microsoft Windows 95, Microsoft Windows 98, or Microsoft Windows NT Service Pack 3.
2. Install Microsoft Office 2000.
3. Install the Oracle 8.05 Client.
4. Click Start, point to Oracle for Windows 95, and then click Net Easy Config.
5. Click Add New Service. Enter the server name, and then click Next.
6. Click TCP/IP, enter the server name as the Host Name, and then click Next.
7. Enter the appropriate Database SID, and then click Next. Click Next again, and then click Finish.
8. 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.
9. Enter the following command to create a table:

   Create table TestError (F1 Number);
   						

   This returns "Table created."
10. Insert a record into the table by entering the following:

    Insert into TestError Values(12.34);
    						

    This returns "1 row created."
11. Enter "Exit" to close SQL Plus 8.0.
12. Using the ODBC Administrator, create a new DSN for the Oracle database that uses the Microsoft ODBC for Oracle driver.
13. Start Microsoft Access 2000, and then create a new database.
14. On the File menu, point to Get External Data, and then click Link Tables.
15. In the Link dialog box, change the Files of type box to ODBC Databases.
16. In the Select Data Source dialog box, click Machine Data Source.
17. Select the DSN that you created in step 12, and then click OK.
18. Enter the appropriate logon information, and then click OK.
19. Find and select the table that you created in step 9, and then, click OK.
20. In the next dialog box, select the field that you created, and then click OK.
21. Open the table in Datasheet view.
    
    Note that the value in the field is #Deleted.

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.