Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / SQL Server / ADP / June 2006

Tip: Looking for answers? Try searching our database.

Form with Combo Boxes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Armando Vargas - 21 Jun 2006 05:05 GMT
Hello!

Im trying to make a form in Ms Access ADP XP, and using a Back end SQL
Server 2000.

Everything is great, and works fine, But I will use this app by Internet.
Any advise in how to improve speed.  Maybe using lees combo boxes?  I use
them so I can select info from records from other tables.

Any advise, help, or link will be great!

thanks!!
Sylvain Lafontaine - 21 Jun 2006 18:01 GMT
Running ADP over the Internet will never be a miracle.  If you take a look
with the SQL-Server Profiler, probably that you will see a lot of redundant
requeryings; particularly when you want to update controls like comboboxes
located on a subforms.

Personally, I've seen a diminution of the number of requeries for the global
form when I directly change the RowSource of these controls instead of
simply requerying them.

Maybe using TS/Citrix will give you some break on that (but of course with
the limitations and cost$ of TS) but a much better solution would be to
rewrite your application using .NET WinForms or ASP.NET.

It's when you want to go over the Internet and that you see the great number
of useless requeryings done by ADP that you will see why Microsoft have made
the decision of slowly deprecating ADP in favor of .NET technologies.
However, a well designed ADP application developed by keeping an eye on the
SQL-Server Profiler will probably gives you an acceptable solution.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> Hello!
>
[quoted text clipped - 8 lines]
>
> thanks!!
Armando Vargas - 22 Jun 2006 01:43 GMT
Thanks for your comments Sylvain

(Y)

Armando

> Running ADP over the Internet will never be a miracle.  If you take a look
> with the SQL-Server Profiler, probably that you will see a lot of
[quoted text clipped - 28 lines]
>>
>> thanks!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.