Form Speed

[M. Wilson]

Hello,

I have a distributed access database. The data.mdb is stored on the network
and the frontend.mdb is stored on my users hard drives. The tables from the
data.mdb are linked in the frontend.mdb.

Here is the problem. I have a very important form which all of the users
use particularly when the are on the phone to lookup data. The form takes a
really really really long time to load. The recordsoure for the main form is
a select statement. There are also eight subforms within the main form. The
recordsource for all of the subforms is a table.

Does anyone know why the form would take so long to load and/or recommend
ways to speed it up?

Thanks,
M. Wilson

 

[Steve Schapel]

M.,

As general concepts to consider:
1. Use queries for the Record Source of the subforms.
2. Leave the subforms empty until and unless they are needed, at which
point populate tham via code by setting either their Source Object or
Record Source properties.
3. If 2. doesn't apply, at least use code to populate the subforms
after the main form is loaded (Access's default behaviour is to load the
subforms before the main form).

There is some good information here:
http://www.granite.ab.ca/access/performancefaq.htm

 

[Richnep]

Hello,

I have a distributed access database. The data.mdb is stored on the network
and the frontend.mdb is stored on my users hard drives. The tables from the
data.mdb are linked in the frontend.mdb.

Here is the problem. I have a very important form which all of the users
use particularly when the are on the phone to lookup data. The form takes a
really really really long time to load. The recordsoure for the main form is
a select statement. There are also eight subforms within the main form. The
recordsource for all of the subforms is a table.

Does anyone know why the form would take so long to load and/or recommend
ways to speed it up?

Thanks,
M. Wilson

Steve is right, a query as the recordsource will speed things up
greatly. It also depends on what is running on the machine that hosts
the backend and what the specs of the BE machine are. Could be you
just need more memory.

 

[BrerGoose]

Go into design view for each table in the front-end, and more importantly the
back-end, and then open the properties. Verify that "Subdatasheet Name"
equals [None]. This is especially important with linked tables that you have.