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