ACC95: Import/Export/Link Text or Spreadsheet Slows Performance (163840)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
This article was previously published under Q163840 Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
After you import, export, or link a text file or spreadsheet file,
Microsoft Access 7.0 performance is noticeably degraded. If you quit and
restart Microsoft Access, performance returns to normal.
CAUSE
When you use the TransferText or TransferSpreadsheet method or action, or
when you use menu commands to import, export, or link a text file or
spreadsheet file, Microsoft Access creates a thread with the highest level
of processor priority. When the action is finished, the thread is not
terminated, which causes performance to degrade.
RESOLUTION
If you notice performance degradation after one of the activities listed
in the "Symptoms" section, quit and restart Microsoft Access. You can
upgrade to Microsoft Access 97 to resolve the problem completely.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 7.0. This
problem no longer occurs in Microsoft Access 97.
REFERENCES
For more information about TransferText and TransferSpreadsheet actions or
methods, search the Help Index for "TransferText action," "TransferText
method," "TransferSpreadsheet action," or "TransferSpreadsheet method."
Modification Type: | Major | Last Reviewed: | 11/17/2000 |
---|
Keywords: | kbbug KB163840 |
---|
|