Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 11th, 2011, 05:49 AM
Friend of Wrox
 
Join Date: Apr 2007
Posts: 110
Thanks: 1
Thanked 2 Times in 2 Posts
Send a message via MSN to ayazhoda
Default Opening access form on different computers - dissimilar process time

Hi All
I have a query which I am trying to access from different computers on the network. On one of them computer it retrieves data very fast and rest of the computers on the network retrieves result from same query very slow.
Query fetch data from SQL server in Access 2007 and Access form show results return from query
I've checked following
  1. Access query is similar which retrieves data from SQL Server on both computer (they are running same code)
  2. I logged on to other computer which is fast and access same query and it was fast so I think user loggon is not issue.
  3. Checking SQL profiler on my computer it is executing two extra query from order table which causes delay but this is not happening with access same query from other computer
Regards
 
Old August 31st, 2011, 11:43 AM
Authorized User
 
Join Date: Mar 2011
Posts: 13
Thanks: 0
Thanked 1 Time in 1 Post
Default

I don't know why it's only running slowly from one computer and not the others. But here are some general considerations (excuse me if this is not new to you).

-Are you avoiding Access functions in the query? Using Access functions (such as Iif() and what not) can force the query to take multiple trips and slow things down
-Have you tried a pass-through query? You won't be able to alter data in the typcial Access way through pass-through queries (they are read-only), but if you can do this for a report or some unbound form, this could significantly improve the speed of a query. This can be some hassle to set up, but I think it's worth it.
-Just to make sure, is there any change in how the file is accessed between computers? Do some access the same file on a server, and one group run it locally on their own machines?
 
Old September 9th, 2011, 02:36 AM
Registered User
 
Join Date: Sep 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Post

Quote:
Originally Posted by ayazhoda View Post
Hi All
I have a query which I am trying to access from different computers on the network. On one of them computer it retrieves data very fast and rest of the computers on the network retrieves result from same query very slow.
Query fetch data from SQL server in Access 2007 and Access form show results return from query
I've checked following
  1. Access query is similar which retrieves data from SQL Server on both computer (they are running same code)
  2. I logged on to other computer which is fast and access same query and it was fast so I think user loggon is not issue.
  3. Checking SQL profiler on my computer it is executing two extra query from order table which causes delay but this is not happening with access same query from other computer
Regards
This happens when your computer needs formatting or some times it depends upon the browser you are using. The computers these days are of very high technology and some times this hig-tech things do not work so properly. As I had an issue with Mozilla6,that use to crash every now and then, but then I used Mozilla4, which is working perfectly fine. I think you might get the solution by trying these tiny things.

Last edited by marry; September 10th, 2011 at 06:52 AM..





Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening access form on different computers - dissimilar process time ayazhoda Access VBA 1 October 4th, 2011 01:23 AM
Kill all winword.exe process before opening Word mckly Pro VB Databases 1 March 6th, 2008 01:34 AM
Issue Opening Form in Access 2007 Laurel Access 0 July 20th, 2007 03:59 PM
process every time anoop.goyal Classic ASP Basics 0 May 25th, 2006 01:18 AM
How to synchronize time on two computers Vladimirs VB How-To 0 June 29th, 2003 06:55 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.