dbTalk Databases Forums  

Slow Office Automation

comp.databases.ms-access comp.databases.ms-access


Discuss Slow Office Automation in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bullfrog
 
Posts: n/a

Default Slow Office Automation - 03-06-2008 , 11:34 AM






My office application is really slow on Windows XP!

First, some backgroud stuff.

The MSAccess system that we use was developed while using Windows
2000, and Office 2000. At our new location, we are using office 2003
and XP. I did not convert the database to 2003 since a few of our
staff have laptops with windows 2000.

I have quite a few functions/macros in MSAccess that outputs to ms
excel, and I am finding that running my program on an XP machine, a
function that used to take 5 seconds, literally can take upwards to
5-10 minutes. If I choose to show excel, I can see the sheet beeing
populated very slowly, like a cell every couple of seconds. If I run
the same on the windows 2000 machine, it runs as it should. It seems
like it is a very slow communication between both programs.

I just received a call from an other office, and they just went
through the XP conversion, and they are experiencing the same symptoms
on a similar Office Automation Application they developed a few years
ago.

I have no idea as to what could be causing this problem.

Thanks in advance.
Sylvain

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.