A
adam c.
I have a split Access 2002 database running on a 2000
network, the BE is networked, the FE is local. the
database regularly see's about 3-4 users on the system.
I'm using a qrydef to populate a listbox for project
selection, that is opened on its own form from a unbound
main menu....
Here's my problem:
the first user can access the project listbox screen
under 1 second, and enter a project with no lag.
The second user however gets a 20 second lag going from
the unbound main menu, to the project list box? and once
in the listbox form can pop any project up without any
lag...
the problem only occurs after one user is in....
Can anyone offer some advice on what to check for that
may be causing the lag? I've got all the service packs
and Jet updates..
Or, provide some direction on reducing the lag!
thanks for any help!!!
Adam
network, the BE is networked, the FE is local. the
database regularly see's about 3-4 users on the system.
I'm using a qrydef to populate a listbox for project
selection, that is opened on its own form from a unbound
main menu....
Here's my problem:
the first user can access the project listbox screen
under 1 second, and enter a project with no lag.
The second user however gets a 20 second lag going from
the unbound main menu, to the project list box? and once
in the listbox form can pop any project up without any
lag...
the problem only occurs after one user is in....
Can anyone offer some advice on what to check for that
may be causing the lag? I've got all the service packs
and Jet updates..
Or, provide some direction on reducing the lag!
thanks for any help!!!
Adam