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

Posted on 2007-08-08
Medium Priority
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
  • 2

Expert Comment

ID: 19669021
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

ID: 19669199

Accepted Solution

vilia earned 2000 total points
ID: 19675828
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

839 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