I have a network based application that has a Access2000 front 
end/Access97 back end. It appears to significantly slow down as the day 
progresses. I'm not sure if it's because of the # of users that are 
concurrently connected to it, or the fact that people have log in/log out 
of it during the day.

Is there any way of checking why the app slows down as the day progresses ?

On Fri, 24 May 2002 14:20:24 "Lloyd Levine" wrote:

> I have a network based application that has a Access2000 front 
> end/Access97 back end. It appears to significantly slow down as the day 
> progresses. I'm not sure if it's because of the # of users that are 
> concurrently connected to it, or the fact that people have log in/log out 
> of it during the day.
> 
> Is there any way of checking why the app slows down as the day
> progresses ?

Are you sure the problem is in your application at all. It could be that 
the network is slowing down due to user load. This would mean that 
almost everything is slow for almost everybody, which you can check 
by the "Hey, Sam" method.

If it's an Access problem, my best guess is that the tables get cluttered 
from insertion/deletion of records and that compacting is required. This 
is not a trivial task in the middle of the day. Sorry I can't do better than 
that.

Paul