Slow Form

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I have a dwhere all the tables are linked from another dBase. I have noticed
that there is a major slowdown in the updating and opening of forms, reports,
etc.

Anyone know why this is?

Greg
 
If you are using bound forms that receive entire tables from the linked
tables, there will be a lot of traffic between the back end and front
end databases. This is especially noticeable over the network. If this
becomes unbearable you may want to limit the recordsets received by the
bound forms to only those records that are displayed using, for
instance, SELECT TOP statement.
Basically, try to reduce the amount of data transferred at each form's opening.

Pavel
 
Is the database that is linked remote (i.e. on a server)?
If so, how is your connection to the network, how is the
server running. If either of them is slow, I would believe
that is the problem. The only other thing, I can think of
is the source of your form data. If it is a query, is
there some problem with the query? Have you set indexes
appropriately on the fields in the table?

Hope that helps!
 
Back
Top