Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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 November 5th, 2006, 04:41 AM
Authorized User
  
Join Date: Apr 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default adp slowness
Access 2000 -> sql server 2000

I'm finding access adp is slow querying data but the same query in enterprise manager or query analyzer is fast.

majority of slowness comes when the combo box wizard is getting the sample values to show you after you choose the table and columns.

client net tools is set to use tcp/ip on :1433

What could be the issue ?
 
Old November 6th, 2006, 08:21 AM
Friend of Wrox
  
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default
Where are the queries? If it is adp, are they views on the server? If so, then they are optimized by SQL, as with EM and QA. If they are not on the server, then they are not optimized and could be slower.



mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
Connection State in ADP Scripts82 Access VBA 3 April 6th, 2006 09:48 PM
Where is the processing done in ADP Scripts82 Access VBA 3 March 23rd, 2006 12:00 AM
ADP OpenReport() ginoitalo Access 8 November 29th, 2004 09:10 PM
MDB vs ADP, once again. leprechaun Access 1 August 5th, 2004 02:01 PM
ADP Menubar ginoitalo Access 2 April 11th, 2004 11:53 PM




Contact Us - Wrox - Privacy Statement - Top

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