Performance Issues - Access 2007

By Michelleguilbeault ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Is it really a SAMBA read-raw issue?

by robo_dev In reply to Performance Issues - Acce ...

Slow performance on MS-Access database can be caused by read-raw setting in Samba:

Most old Bufallo NAS boxes are just samba boxes in disguise.

Collapse -

Same for Access 2007?

by Michelleguilbeault In reply to Is it really a SAMBA read ...

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?

Related Discussions

Related Forums