Question Locked

Performance Issues - Access 2007

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have recently converted an application from Access 2000 to Access 2007 with no new functionality, just a straight conversion. The application runs as it did previously when we test it on a local computer. Once we migrate the back end to the Linux server we notice a marked slowdown in performance. It's equally slow with the back end on a Buffalo stand-alone hard drive. A form that used to open in 3 seconds now takes 30 seconds. Service Pack 1 is installed. The front end is installed on both Windows XP and Vista machines with no marked difference in performance.

Users are frustrated by the slow performance. Is this slow down normal? Any suggestions on how to speed things up? The forms are large forms, but the main user doesn't want to change the existing app.

I'd appreciate any suggestions.

3 replies

by michelleguilbeault

Thank you for your reply. The performance of the Access 2000 database on the same server was fine. The problem began when we converted to Access 2007. Do you think the Access 2007 Trust Center settings can be the cause of the slowdown? Would the Samba settings described in these two articles be affected?

This discussion is closed to new replies.