Searching forever on Access 97 runtime

L

Lars Gustavsson

Hi!
I have an Access 97 app that is splited into a frontend and a backend
database. The backend is about 40 MB in size.

I have a search form where the user can search trough 6 text fields,
where 4 of them is MEMO fields. I know they can't have index, to speed
things up. When I search on my development computer (Win2000) a search
will take about 5-10 seconds at the most. But when searching at the
customers computer (Win NT Server with Citrix) it sometimes search
forever. The customer have a swedish Access 97 runtime edition, and I
have the real english Access 97 version. When this happends to a user,
he or she have to kill the Citrix session because it seems be
searching for ever.

I would appreciate any comments on this behaviour.

TIA
 
R

Rick Brandt

Lars Gustavsson said:
Hi!
I have an Access 97 app that is splited into a frontend and a backend
database. The backend is about 40 MB in size.

I have a search form where the user can search trough 6 text fields,
where 4 of them is MEMO fields. I know they can't have index, to speed
things up. When I search on my development computer (Win2000) a search
will take about 5-10 seconds at the most. But when searching at the
customers computer (Win NT Server with Citrix) it sometimes search
forever. The customer have a swedish Access 97 runtime edition, and I
have the real english Access 97 version. When this happends to a user,
he or she have to kill the Citrix session because it seems be
searching for ever.

I would appreciate any comments on this behaviour.

TIA

Not much you can do probably. The full contents of all of those memo fields is
being dragged across the network so they can be scanned for matches. Are you
applying criteria to all 6 fields or only the ones the user enters criteria for?
 
V

Van T. Dinh

* 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.

* 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 .

* 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top