Performance Issue on Split Database

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
 

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