Connection issue

[Sam]

I am having network traffic problems (backend sql 2008).
If I use a passthrough to pull a lot of data, and then use local queries for
subsets of that, will that cause less network traffic than individual
passthroughs? These are mostly for pick lists so the data is static.

Also, is there a way to tell how many connections a user has to the server
at any given moment? I connect mostly throught ADODB OLE DB connections.

Thanks for the help.
Sam

 

[Jerry Whittle]

If the data is pretty static, you might want to consider putting the data in
a local Access db tables and updating those tables once a day or so as
appropriate.

 

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

wow, that's silly..

If your data _IS_ in SQL.. and you're tired of dealing all the Jet
B.S.; then I wouldn't hesitate to look towards 'Access Data Projects'
and a much simpler architecture.

Jet just isn't as efficient as Access Data Projects.
Jet doesnt' work over wireless.. Syncing all your data to Access
tables is just a total waste of time, processing power, storage, and
memory.

-Aaron

 

[Larry Linson]

I am having network traffic problems (backend sql 2008).
If I use a passthrough to pull a lot of data, and then use local queries for
subsets of that, will that cause less network traffic than individual
passthroughs? These are mostly for pick lists so the data is static.

Also, is there a way to tell how many connections a user has to the server
at any given moment? I connect mostly throught ADODB OLE DB connections.

What version of Access are you using? Are you using an ADP/ADE, MDB/MDE, or
an ACCDB/ACCDE front-end?

The Product Team has not enhanced ADPs for the last few releases and no
longer recommends it as the method of choice for an Access client to
Microsoft SQL Server. As such lack of enhancement often means a lack of
sufficient customer interest and foreshadows a "deprecation" of the feature.
No deprecation of ADP has been announced, but I would not recommend creating
a new Access database application with an ADP.

Personally, I also would avoid using ADO, because in what Microsoft
perceives as the "world of real development", that is DotNet, classic ADO as
used in Access has already been superceded by ADO.NET, which has a different
object model, and is not based on OLE DB.

If you obtain your data from the server at a low-use time of day, and then
use it from the Access tables, you might see some performance gains. How
significant, or even perceptible, those gains might be will depend on a
great many factors.

I'm not sure how you would use "the number of connections to the server" in
your Access application if you did have them. Just as a matter of interest
to me, could you explain how you intend to make use of that information?

Larry Linson
Microsoft Office Access MVP

 

[Jerry Whittle]

Hi Aaron. Long time no see. Released from jail or just fired again?

 

[De Jager]

I am having network traffic problems (backend sql 2008).
If I use a passthrough to pull a lot of data, and then use local queries
for
subsets of that, will that cause less network traffic than individual
passthroughs? These are mostly for pick lists so the data is static.

Also, is there a way to tell how many connections a user has to the server
at any given moment? I connect mostly throught ADODB OLE DB connections.

Thanks for the help.
Sam