Access 2010 running super slow from server

Question

I recently upgraded to Office 2010.  My db was originally developed in access 2000.  The db is saved on a server, which I have only access to, no programming privileges.  Now, my database is running super slow.  Example:  I have switchboard open in design view, I change the border style and switch to form view to see the result.  Form view comes up instantly, no problem.  However, whenever I change back to design view to make any additional changes, I must sit and wait.  I never know how long I will have to wait.  We're talking several minutes here...I only started having this problem when I switched to 2010.  Any suggestions?

Even working from a copy on my local computer runs slow.

Answer 1

Are you sying the entire UNsplit database is on the Server?  I am surprised this is the first time you experienced slowness.  Typically you would plit the database and keep the front end (where you would be making your changes) on your local (which is where everybody's FE should be).

Before I go any further... please confirm if the first sentence is true?

---

-- Gina Whipp 2010 Microsoft MVP (Access) Please post all replies to the forum where everyone can benefit.

Answer 2

All components of the db are on the server.  There is an unsplit version and a split version. I pulled a copy onto my local and converted it to a 2007 db.  Having the same problem.

Answer 3

Well, not the way it's typically done but let's check these first...

http://www.granite.ab.ca/access/performancefaq.htm

---

-- Gina Whipp 2010 Microsoft MVP (Access) Please post all replies to the forum where everyone can benefit.

Answer 4

ajschiffli,

If you pull the Unsplit DB (with NO ODBC connections at all?) to our local hard drive - do you still experience the issue, or is it only on the split version or when either is on the network?

I'm beginning to suspect that there might be an ODBC config issue at play here.

What OS are you using, and is it a 32-bit or 64-bit platform?

 

 

Answer 5

Yes, I still experience the issue.  I have Windows 7 with a 32-bit platform.

Answer 6

It's a brand new computer.

Answer 7

Have you worked your way thru the Performance Issues list?

---

-- Gina Whipp 2010 Microsoft MVP (Access) Please post all replies to the forum where everyone can benefit.

Answer 8

Gina,

I was trying to elimiinate any 32-bit/64-bit issues (which Tony doesn't yet have on his otherwise fantastic list).

 

Answer 9

I've done it off and on.  Going back through it again.  It's going to take a little while.

Answer 10

Mark,

I see your point but I believe some of those issues apply across the board...

---

-- Gina Whipp 2010 Microsoft MVP (Access) Please post all replies to the forum where everyone can benefit.

Answer 11

No luck.  I'm wondering if the problem is coming from some of the tables I'm linked to.  They are in a database to which I have access, but do not have "permission" to make programming changes to.

Answer 12

ajschiffli,

so even with your copied-local, UN-split database you DO have ODBC connections to external data tables?

Try this test:

make a copy of that database (locally).

remove ALL the connected external ODBC tables/etc.

compact & repair.

reopen that copy of the db and try to do any of the things (NOT involving those now-missing external tables) which WAS being slow previously and see if there is any noticable difference.

I am simply trying to eliminate network/ODBC issues from the equation. If this entirely-local databse is still slow, then we have other things to consider, if it runs fine with no network/ODBC issues in place, then we can try to re-establish those things step by step and see where it falls down. (starting with running the still-un-connected db off the server.)

 

Answer 13

I have the same problem with the db on a 32bit Server 2003 and the local computer a 64bit Windows 7 box.

What is the best way to speed this up?

Answer 14

Please expalin.. is it split?  Are you trying to run from the Server?

---

Gina Whipp
Microsoft MVP (Access)
Access Tips: www.access-diva.com/tips.html
Blog: http://regina-whipp.com/blog/