Slow response time in Access

Question

I have a user who we switched from an XP SP3 machine to a Windows 7/64-bit machine. Our ERP system runs with a SQL back end and an Access 2007 front end. Since moving this user to the Windows 7 machine, she is experiencing delays when opening reports in the ERP system. (She has Office 2003 but Access 2003 is not on her machine. The ERP software uses the Access 2007 runtime.) The report (one invoice) can take anywhere from 20 seconds to two minutes to open. If I log into her machine (I am a domain administrator,) the report opens immediately. I have talked with the ERP vendor and he does not believe the problem is with the application but with our network. This doesn't make sense to me since I get immediate response time on the same machine opening the same report.

Below are the steps I have taken so far. I am at a loss as to what is causing this.
1. Recreated her profile.
2. Changed default printers.
3. Made her a local admin on her machine.
4. Made her a dbo owner on the database in SQL.
5. Checked all permissions to the folder where she is pulling in the ADE to make sure she has full permissions on the folder and all objects in the folder. Also, gave her full permissions to the trusted location in the registry.
6. Logged in as her on a different Windows 7 computer. Reports are slow to open.
7. Logged in as a different (non-administrator) user and reports are slow.
8. Logged in as a different domain administrator. Reports open immediately. However, we have one more domain administrator that when I log in as him, the response time is slow.
9. Turned off firewall. Turned off anti-virus.
10. Made the user a domain administrator.
11. Made the user a local administrator on the server that houses the ERP software.

This sounds like a permission issue to me but I can't figure out what needs the permissions for non-domain administrators.

Note that my manager and I are both domain administrators and we also use SQL to create queries, jobs, etc. We are dbo owners on the database. We have a 3rd domain administrator who does not use SQL and he gets the slow response time like the user.

Answer 1

Hi BettyN,

Thank you for posting.

As far as I know, you can refer to the article about performance tips for Access 2007:

http://msdn.microsoft.com/en-us/library/dd942824(v=office.12).aspx

Hope you can get some hints from the article.

Best Regards,

---

Bruce Song [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Two things I have had trouble with in the past...

1) When making the .accde make sure have the tables Linked using the UNC path and not a mapped drive.

2) Create the UI in the network folder the backend is in or on the users machine.

---

Chris Ward

Answer 3

How is the database communicationg with SQL? If it is using a driver, where is the driver? Maybe this user has a different version of the driver?