Access 2007: Form Load Performance Issue

[AccessARS]

I have a very puzzling situation with my Access 2007 VBA interface...the file
in question is a stand-alone on an end-user desktop with a SQL Server
back-end. The functionality is to generate and display parameter driven
aggregate data through custom forms , subforms and charts. I have started
testing with 40+ users and three seem to experience an unusual delay in
displaying the local formulas and charts as follows:

The form normaly takes approximately 15 seconds to open with everything
dispayed. The three machines in question open the form after 10 seconds only
displaying the data retrieved from SQL but continue to calculate the local
formulas and charts for another 2 minutes.

All the test cases are running on WindowsXP but the three anomolies are
Vista technology running on XP. The way I can tell this myself is that they
have a Vista sticker on the machine but running XP.

I have debugged the application on all three machines to pin point the lag
to the local formulas and charts. The SQL server queries run on time at
which point I have the data stored locally in temp tables. Thereafter the
form opens at 10 seconds which triggers the local formulas and charts to run
off of the local temp tables.

In my research I have found the following link...
http://www.granite.ab.ca/access/performancefaq.htm
....the first part looks interesting but not sure if it applies to my case
considering that the problamatic machines are brand new with a fresh Office
2007 installation not an upgrade from 2003.

Thank you in advance for your time.

 

[a a r o n _ k e m p f]

wow.. it souinds to me like you're drikning the wrong kool-aid

SQL Server with linked tables.. is just a waste of time.

Move to access data projects, and your queries / tables run a LOT
better

Jet linked tables have to download the whole SQL Server table to the
local machine in order to store it on disk.. and then compare it to
other data.
Jet is lke the worst architecture for databases-- of all time.

That's why SQL server is the worlds most popular databases-- because
Jet sucks a big fat hairy dick

-aaron

 

[AccessARS]

To clarif, I don't have linked SQL tables running in my Access
queries...Stored Procs and Pass-through queries are my source to the
back-end. I'm glad that my question gave you the opportunity to vent but it
would be great if you were this knowlegeable about the issue in hand.

Regards

 

[BruceM]

lol

To clarif, I don't have linked SQL tables running in my Access
queries...Stored Procs and Pass-through queries are my source to the
back-end. I'm glad that my question gave you the opportunity to vent but
it
would be great if you were this knowlegeable about the issue in hand.

Regards