Microsoft KB Archive/243467

Knowledge Base

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.

MORE INFORMATION

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.

REFERENCES

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.

Additional query words: pra pound deleted number sign

Keywords: kbbug kbfix KB243467

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.