If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form Speed
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 |
#2
|
|||
|
|||
Form Speed
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 he http://www.granite.ab.ca/access/performancefaq.htm -- Steve Schapel, Microsoft Access MVP M. Wilson wrote: 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 |
#3
|
|||
|
|||
Form Speed
On Oct 27, 2:14 pm, M. Wilson
wrote: 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. |
#4
|
|||
|
|||
Form Speed
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. -- BrerGoose Moose-Tech Softwa http://ourworld.compuserve.com/homep...e/MTS/Home.htm |
Thread Tools | |
Display Modes | |
|
|