Searching forever on Access 97 runtime

[Lars Gustavsson]

* Is the Back-End located on the Citrix server

(or at least in the same LAN) >as the Citrix
server? If it is not, there will be a lot of
traffic going through probably a small pipe.

The Back-End and Front-End are located on the same computer and in the
same directory. They are separated so I easily can be making updates
to the Front-End, offline.

* Beware that on your PC, you are likely
to have more RAM than a user on Citrix.
I got a Citrix se-up with 40+ users, only
about 20 are "regular" users and one time
I saw there were 22 instances of Access
running on the server - each user needs
a separate instance of Access (and the
Front-End) so they may be restricted
with the allocated memory .

My laptop has only 192 Megs of ram, somI think there must be another
issue here. I tried to search at the customers computer yesterday and
I was the only user and it worked once. All other searches there after
was never ending.

* You may need to think of another
strategy so that you don't need to
search the Memo Fields. I never
allow the users to search the Memo
Fields.

Yes, but how, that's hardest to find out.


L Gustavsson, SWEDEN

 

[John Vinson]

Yes, but how, that's hardest to find out.

It depends on what information in the memo fields needs to be
searched. If you can identify keywords or short (<255 byte) key
phrases, you could (using an overnight batch query) create a "many"
side table containing the keywords for each record by finding them in
the memo fields and appending to a new table. Here they could be
indexed, allowing a much faster search.

If you need full text-base capabilities (key words in context or
"KWIC" searching, proximity searching, automatic grammatical
generalization such as searching for "find" and having it
automatically include "found", etc) you'll need a different program.

John W. Vinson[MVP]