[MS_AccessPros] MS Access too slow on new remote (hyper v) computer

 

Hello all,

We are experiencing overly slow behavior of MDB files on remote computer.

I believe it is some strange MS Access problem.

That has nothing to do with bad database design or poor coding skills.

To test

=======

I used a wonderful tool from... ( a self contained MDB file with no Linked Tables )

http://pcesoft.com/Access-Spell-Checker-Tool-Source-Code.html

I entered very long text into it - some 5000 words 

( copy pasted contents from https://en.wikipedia.org/wiki/Seattle )

On my local PC it took 1 minute and 40 seconds to complete the spell check.

On the other hand, ( the new remote PC )

Same spell check tool, took 5 minutes to finish..

Local PC:

Access 2007 on Windows 7

Intel Core i5 2400CPU @3.1Ghz with 16Gb RAM

Remote PC:

MS Access Office 2003 with SP3 (32bit)

Remote Desktop 

Windows 2012 R2 (64bit)  (hyper-v)

Intel Zeon E7 4860 @2.27Ghz  with 50Gb RAM

Any ideas?

Thanks

Ozair

P.S. On remote PC, I tested Access 2013 64 bit as well. It was even slower - took 6 minutes.

__._,_.___

---

Posted by: ozairkhalid@hotmail.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___