We are experiencing slowdown in our Microsoft Access 2000 Program / Microsoft Access 97 Data application. Sometimes it takes a minute or longer to open a record. This should take a few seconds. This application has been running for about 7 years. We've gone through the program and indices and haven't noticed anything that would cause this. We've imported the data into a new database then archive off about 30% of the data. The data size was 560MB but is now 400MB.
ENIVRONMENT: We are now using Citrix Presentation Server 4.5 with Application Isolation.
We have moved to virtual servers and a SAN during the last year. Other Citrix applications run fine, only this particular MS Access apps. This application is using Citrix Application Isolation and I was interested if this could be a problem area. We have had a fair amount of changes in the last 12 months and we cannot pinpoint when this started or what may be causing the slow down.
Thank you for your assistance.