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:48 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
Regard
 
Old October 4th, 2011, 01:23 AM
Registered User
 
Join Date: Oct 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Put instead your computers local host the IP address of server where you have ccnet
for example it would look something like this: http://192.168.1.66/ccnet
Of course I typed some default IP you need to check what's yours.
Also check if firewall is not blocking access.





Similar Threads
Thread Thread Starter Forum Replies Last Post
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
Builiding a time triggered process zicaden Pro PHP 4 September 10th, 2003 04:44 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.