Microsoft Jet creates temporary indexes on your local machine when you query a database. This occurs even when the database is remotely located and in a different file format. These indexes can be as small as a few kilobytes or as large as several megabytes, depending on the data source.
You must make sure users of your application have sufficient resources to accommodate these temporary space needs. All users should have a defined value for the TEMP environment variable and enough disk space to store the indexes that Microsoft Jet may create.
Important If users lack the disk space necessary to store temporary indexes, your application may behave unpredictably.