Complex Queries on Terminal Services

#11

"Bob Darlington" <bob (AT) notheredpcman (DOT) com.au> wrote in
news:4dd8506a$0$22471$afc38c87 (AT) news (DOT) optusnet.com.au:

Quote:

"David-W-Fenton" <NoEmail (AT) SeeSignature (DOT) invalid> wrote in message
news:Xns9EEC9DFEAD94Df99a49ed1d0c49c5bbb2 (AT) 74 (DOT) 209.136.93...
"Bob Darlington" <bob (AT) notheredpcman (DOT) com.au> wrote in
news:4dd6f698$0$15070$afc38c87 (AT) news (DOT) optusnet.com.au:

Further to my previous post, all users are using TS connections
to access the program.
And this morning I noticed a 'Not Responding' message in the
application title bar. It goes away when the process eventually
completes.

Sounds like a memory/caching issue.

I assume the fields being selected on are appropriately indexed?

I don't know if a table can be 'over indexed' but if so, I've done
it. And I've even tested with most of the indices removed.
Could you give me a pointer to where to look for a solution
regarding the 'memory/caching' issue?

I have none. It would be a Terminal Server configuration issue, if
it were involved at all, and I've never run an Access app under WTS
except with bog-standard default settings (i.e., never any need to
change any of the advanced settings).

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#12

"Bob Darlington" <bob (AT) notheredpcman (DOT) com.au> wrote in
news:4dddb48e$0$22470$afc38c87 (AT) news (DOT) optusnet.com.au:

Quote:

When you refer to 'memory / caching' are you talking about
something which can be controlled through Access or something in
the operating system or server software?

I was referring entirely to Terminal Server settings.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#13

Thanks David.
I'll do some more research.

--
Bob Darlington
Brisbane
"David-W-Fenton" <NoEmail (AT) SeeSignature (DOT) invalid> wrote

Quote:

"Bob Darlington" <bob (AT) notheredpcman (DOT) com.au> wrote in
news:4dddb48e$0$22470$afc38c87 (AT) news (DOT) optusnet.com.au:

When you refer to 'memory / caching' are you talking about
something which can be controlled through Access or something in
the operating system or server software?

I was referring entirely to Terminal Server settings.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Complex Queries on Terminal Services

comp.databases.ms-access comp.databases.ms-access

Re: Complex Queries on Terminal Services - 05-28-2011 , 02:14 PM

Re: Complex Queries on Terminal Services - 05-28-2011 , 02:15 PM

Re: Complex Queries on Terminal Services - 05-29-2011 , 05:35 PM