Import Error in Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm getting the following error message when importing a table through ODBC

ODBC--call failed
[ATI][OpenRDA ODBC] Error initializing the cache for disk storage (#o

I'm using MS Jet (SP 8) / Access 2000 (9.0.2720)
on Windows 2000 Professional, on an 11mb wireless network
The table I'm trying to import is rather large - could this be the cause of the problem
I'd prefer to import the table instead of simply link it

Anyone have any ideas

Thanks in advance
David L.
 
OK way after the original post but I ran into the same issue with
MYOB/Access and found a couple workarounds.

First is to put a dummy UNION on the end of the SQL.

SELECT * FROM MYOB_SalesHistory
UNION
SELECT * FROM MYOB_SalesHistory WHERE 1=2

This forces the query to NOT use disk cache but to dump to RAM instead.

The REAL solution is probably you need to create the cache folder. In the
Windows directory there should be a file called openrda.ini. There should be
a string with :

CacheOptions=PATH=C:\MYOBODBC\cache;INITIAL_SIZE=1
0;INCREMENT_SIZE=5;MAX_SIZE=5000;DATABLOCK_SIZE=64

What you want to look for is the path variable. The cache folder did not
exist in C:\MYOBODBC when I looked--I created the cache folder and the
queries now run.

Jake
 
Back
Top