J
Joe Williams
Hello,
I have a standard front end/back end setup. The front end is copied to the
client computer using Tony toews utiity and the back end is on the network
server on a hidden share. The network is 100MB.
The problem I am having is that I am seeing a performance issue with this
configuration. It takes 5-6 seconds to pull up an employee form for a
certain employee (only one record.)
I have a form (frmListEmployees) that lists all employees. when they double
click a specific employee number, it opens the employee form (frmEmployee)
with the following code: DoCmd.OpenForm "frmEmployee", , , "EmpID = " &
Me.EmpID
The recordsource for the form itself is the EMPLOYEES table.
Admittedly, on my machine (2.8 ghz, 2 GB RAM) it pulls up immediately, but
the clients are still decent machines (2.0GHZ, 512 or better RAM) machines
and it still takes 5-6 seconds to pull up one employee record.
Is there a better or more efficient way to pull up the form than I am doing?
Is somehow the fact that the recordsource for the form is the entire table
resulting in the delay I am seeing, even though I am pulling up the form for
one employee only?
Thanks
joe
I have a standard front end/back end setup. The front end is copied to the
client computer using Tony toews utiity and the back end is on the network
server on a hidden share. The network is 100MB.
The problem I am having is that I am seeing a performance issue with this
configuration. It takes 5-6 seconds to pull up an employee form for a
certain employee (only one record.)
I have a form (frmListEmployees) that lists all employees. when they double
click a specific employee number, it opens the employee form (frmEmployee)
with the following code: DoCmd.OpenForm "frmEmployee", , , "EmpID = " &
Me.EmpID
The recordsource for the form itself is the EMPLOYEES table.
Admittedly, on my machine (2.8 ghz, 2 GB RAM) it pulls up immediately, but
the clients are still decent machines (2.0GHZ, 512 or better RAM) machines
and it still takes 5-6 seconds to pull up one employee record.
Is there a better or more efficient way to pull up the form than I am doing?
Is somehow the fact that the recordsource for the form is the entire table
resulting in the delay I am seeing, even though I am pulling up the form for
one employee only?
Thanks
joe