Gary Kjos
garykjos at gmail.com
Mon Sep 16 16:34:27 CDT 2013
Is there anti-virus software running on the server that might be scanning the Access file as it's running? perhaps something with the exceptions list to exclude the Access file data type was changed? Have you tried a compact and repair on the copy of the access database running on the server? Just tossing some things out there. GK On Mon, Sep 16, 2013 at 2:14 PM, Brad Marks <BradM at blackforestltd.com>wrote: > All, > > We have a high level Access 2007 Report that is generated every night. > The data for this report is pulled from a number of SQL-Server database > tables. > > This report is automatically generated nightly on a server with these > specs - > MS Window Server 2003 R2 Enterprise Edition SP2 > 2.50 Ghz > 12 GB Ram > > About a month ago, I noticed that the "run time" for generating this > report went from 8 minutes to 20 minutes. Everything works fine, except > that the run time has more than doubled. > > I can also run this same report on a stand-alone PC with these specs - > Windows XP SP3 > 2.50 Ghz > 3.25 GB Ram > > When the same report is generated on this PC, the job runs for about 8 > minutes. > > Over the weekend, when nothing else was running, I conducted a number of > tests to confirm what I was seeing. > > The results were consistent. The generation of this report takes more > than twice as long on the Server as compared to the PC. > > I am very puzzled and not sure where to look. > > I don't know why the run times went up dramatically on the Server. > > I don't understand why the run times vary between the two boxes. > > Any insights or advice would be most appreciated. > > Thanks, > > Brad > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com