Form loading problem

R

Roy

got a mdb file in a server, in my factory.
1 of the forms, uses sow many subforms, that the time waiting for the form
to come is above 1 minute.
maybe is the server beeing slow.. i don't know...
but, is there any way of geting this DataBase quicker, by SQL Statements
Can a subform have a SQL insted of a query?

Any Help will be very gretfull.
 
A

Arvin Meyer

In order to avoid this problem. as well as greatly reduce the chance of
corruption. You MUST split the database into a front-end with all the code,
forms, reports, etc. running on each workstation and linked to a back-end
with the data tables only, running on the server. You must judiciously index
and fields required for connecting subforms to main forms, and any fields
used in combo boxes and lookup tables, as well as and search fields.

Saved queries are generally faster than SQL statements because they are
compiled upon first running.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
J

Jeff Boyce

Roy

I suspect you've already identified the problem ... you have "so many
subforms" that the main form takes too long to load.

Queries are SQL statements, so you'd have to do some experimenting to see if
you could speed any of them up.

Another approach would be to decide that you don't need ALL of the subforms
loaded when the main form loads. Perhaps you only need to see one? If you
used a tab control to hold many "pages", and each page held a subform, you
could "wait" to load a subform until its page/tab was selected.

Of course, the standard approach of ensuring that your data is
well-structured, and suitably indexed is the first place to look (but you
didn't provide any information about these characteristics).
 
Top