When you use a version of Microsoft Access earlier than Access 97 to link to a very large Microsoft Excel spreadsheet, your computer may appear to stop responding when you attempt to create a report.
↑ Back to the top
This behavior can occur because it may take 30 minutes or more to create a report when a version of Access earlier than Access 97 is linked to a very large Excel worksheet.
NOTE: A marginally adequate computer (Pentium 100 with 32 megabytes [MB] of RAM) may take more than 4 hours to complete this task.
↑ Back to the top
Your computer has not stopped responding, and everything operates as expected after the report has been created.
↑ Back to the top
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
↑ Back to the top