ESRI, Arcview, 9.2 Error adding tables and/or creating DBFs in Arccatalog

Posted on 2007-08-08
Last Modified: 2013-11-05
When trying to even view an Excel 2007 table in ArcCatalog I get an error saying: There was an error initializing the table window. If the table does not have an OID field, ensure that a temporary file can be created in the TEMP directory, so the cable can be copied locally. General function error.

I've tried saving the file in older excel formats and have even created a new table with the same data.  Excel 2007 wont let you save as a DBF but even saving as a csv hasn't worked. Any ideas?
Question by:meixell
    LVL 5

    Expert Comment

    MS Office Apps some time give funny errors.
    It is possible the error is related to access rights of Windows OS.
    What is the Windows Account you are running the ArcCatalog from?

    Author Comment

    LVL 5

    Accepted Solution

    If you run apps from Windows Administrator account, they should not have access rights problem.

    To clear eventual possibility you should temprarly assign full access rights to Evryone for:
    \Documents and Settings\Administrator\Local Settings\Temp

    \winnt\temp could be the one that causes the error as MS Jet Engine writes temp files there. Files like JEThhhh.TMP (hhhh is a hex number). Excel uses Jet.

    (Do not forgert to REVOKE access rights you have granted.)

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    Read about achieving the basic levels of HRIS security in the workplace.
    This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
    This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now