Prev: How do I change the order that my records appear in in Forms
Next: Set Controls Default Value from another Control
From: jenniferspnc on 22 Feb 2010 11:35
Okay I'm back again, with the same problem, and at a loss. This is my 2nd
database, and same brick wall! The loading of my form takes upwards of 40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft and
once split it slowed down dramatically as well...takes a solid minute to load
their form. Could that suggest that my database design is solely not the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source, Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value, Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID, Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource properties of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event load
the appropriate SQL." I have three combo boxes, details to follow below.
This may be the important piece I am missing only because I am confused on
how to go about. If this is the culprit of my design could someone please
help me with what the appropriate SQL that should be loaded on the Event page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this database.

Thanks!
From: Steve on 22 Feb 2010 12:02
Hello Jennifer,

I provide help with Access, Excel and Word applications for a very nominal
fee. I would like to offer to take a look at your database and see what is
needed to fix it. If it can be fixed, my fee would be very modest. There
would be no charge if it can not be fixed. Give me a chance to try to get it
downto couple of seconds. Contact me.

Steve
santus(a)penn.com


"jenniferspnc" <jenniferspnc(a)discussions.microsoft.com> wrote in message
news:91AC5679-CC9E-48C3-A042-9DC3B0125FAF(a)microsoft.com...
> Okay I'm back again, with the same problem, and at a loss. This is my 2nd
> database, and same brick wall! The loading of my form takes upwards of 40
> seconds to load. I've gone through steps offered at previous posts
> (http://www.granite.ab.ca/access/performancefaq.htm).
>
> I even downloaded a template database (sales pipeline) from Microsoft and
> once split it slowed down dramatically as well...takes a solid minute to
> load
> their form. Could that suggest that my database design is solely not the
> problem and perhaps the network doesn't help?
>
> Details of my database: My form pulls off a query (query takes about 10
> seconds for 20 records), SQL is
> SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
> Opportunity.Business_Segement, Opportunity.Source,
> Opportunity.[Opportunity
> Details], Opportunity.Status, Opportunity.Opportunity_Value,
> Opportunity.GP,
> Opportunity.Timeframe_Months, Opportunity.Client_ID,
> Opportunity.Approval_ID,
> Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
> FROM Opportunity;
>
> I have 3 subforms but those seem to load fairly quickly when run
> individually (3-5 seconds).
>
>
> I've read, "Delete the SQL from the RecordSource and RowSource properties
> of
> the form, subforms, comboboxes and listboxes. Now in the Form_Load event
> load
> the appropriate SQL." I have three combo boxes, details to follow below.
> This may be the important piece I am missing only because I am confused on
> how to go about. If this is the culprit of my design could someone please
> help me with what the appropriate SQL that should be loaded on the Event
> page?
>
> Combo Box Details:
> Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
> Table/Query
>
> Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
> Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
> [Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source Type
> Table/Query
>
> Segment: Control Source Business_Segment/Row Source
> "Corp";"Mid";"Other"/Row Source Type Value List
>
> Please help. I hear grunts when people have to enter data into this
> database.
>
> Thanks!


From: Gina Whipp on 22 Feb 2010 12:28
jenniferspnc,

So far nothing you have shown explains the slowness... What version of
Access? On a *copy* of the database have you tried removing the subforms
and adding them back one at a time while checking the load time to see if
one of those subforms is the issue?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"jenniferspnc" <jenniferspnc(a)discussions.microsoft.com> wrote in message
news:91AC5679-CC9E-48C3-A042-9DC3B0125FAF(a)microsoft.com...
Okay I'm back again, with the same problem, and at a loss. This is my 2nd
database, and same brick wall! The loading of my form takes upwards of 40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft and
once split it slowed down dramatically as well...takes a solid minute to
load
their form. Could that suggest that my database design is solely not the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source, Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value, Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource properties of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event
load
the appropriate SQL." I have three combo boxes, details to follow below.
This may be the important piece I am missing only because I am confused on
how to go about. If this is the culprit of my design could someone please
help me with what the appropriate SQL that should be loaded on the Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!


From: Daniel Pineault on 22 Feb 2010 12:52
Come on Steve! Does it never end. People come here for free help, not a
sale pitch!

If you have constructive advice to give on how they can try to resolve their
given problem, then give it. Otherwise, just don't answer.
--
Daniel Pineault




"Steve" wrote:

> Hello Jennifer,
>
> I provide help with Access, Excel and Word applications for a very nominal
> fee. I would like to offer to take a look at your database and see what is
> needed to fix it. If it can be fixed, my fee would be very modest. There
> would be no charge if it can not be fixed. Give me a chance to try to get it
> downto couple of seconds. Contact me.
>
> Steve
> santus(a)penn.com
>
>
> "jenniferspnc" <jenniferspnc(a)discussions.microsoft.com> wrote in message
> news:91AC5679-CC9E-48C3-A042-9DC3B0125FAF(a)microsoft.com...
> > Okay I'm back again, with the same problem, and at a loss. This is my 2nd
> > database, and same brick wall! The loading of my form takes upwards of 40
> > seconds to load. I've gone through steps offered at previous posts
> > (http://www.granite.ab.ca/access/performancefaq.htm).
> >
> > I even downloaded a template database (sales pipeline) from Microsoft and
> > once split it slowed down dramatically as well...takes a solid minute to
> > load
> > their form. Could that suggest that my database design is solely not the
> > problem and perhaps the network doesn't help?
> >
> > Details of my database: My form pulls off a query (query takes about 10
> > seconds for 20 records), SQL is
> > SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
> > Opportunity.Business_Segement, Opportunity.Source,
> > Opportunity.[Opportunity
> > Details], Opportunity.Status, Opportunity.Opportunity_Value,
> > Opportunity.GP,
> > Opportunity.Timeframe_Months, Opportunity.Client_ID,
> > Opportunity.Approval_ID,
> > Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
> > FROM Opportunity;
> >
> > I have 3 subforms but those seem to load fairly quickly when run
> > individually (3-5 seconds).
> >
> >
> > I've read, "Delete the SQL from the RecordSource and RowSource properties
> > of
> > the form, subforms, comboboxes and listboxes. Now in the Form_Load event
> > load
> > the appropriate SQL." I have three combo boxes, details to follow below.
> > This may be the important piece I am missing only because I am confused on
> > how to go about. If this is the culprit of my design could someone please
> > help me with what the appropriate SQL that should be loaded on the Event
> > page?
> >
> > Combo Box Details:
> > Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
> > Table/Query
> >
> > Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
> > Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
> > [Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source Type
> > Table/Query
> >
> > Segment: Control Source Business_Segment/Row Source
> > "Corp";"Mid";"Other"/Row Source Type Value List
> >
> > Please help. I hear grunts when people have to enter data into this
> > database.
> >
> > Thanks!
>
>
> .
>
From: Daniel Pineault on 22 Feb 2010 13:12
I know one issue I have had was entirely related to network/server
performance. What is the path to your db? How many sub-directories deep is
it place on the server?

If you can, try placing the back-end on the very top level (no
sub-directories) and see if speed improves.

Each user has their own copy of the Front-End?
Each user has their copy placed on their own PC, not on the server?
The database is maintained (compacted and repair from time to time)?
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"jenniferspnc" wrote:

> Okay I'm back again, with the same problem, and at a loss. This is my 2nd
> database, and same brick wall! The loading of my form takes upwards of 40
> seconds to load. I've gone through steps offered at previous posts
> (http://www.granite.ab.ca/access/performancefaq.htm).
>
> I even downloaded a template database (sales pipeline) from Microsoft and
> once split it slowed down dramatically as well...takes a solid minute to load
> their form. Could that suggest that my database design is solely not the
> problem and perhaps the network doesn't help?
>
> Details of my database: My form pulls off a query (query takes about 10
> seconds for 20 records), SQL is
> SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
> Opportunity.Business_Segement, Opportunity.Source, Opportunity.[Opportunity
> Details], Opportunity.Status, Opportunity.Opportunity_Value, Opportunity.GP,
> Opportunity.Timeframe_Months, Opportunity.Client_ID, Opportunity.Approval_ID,
> Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional Notes]
> FROM Opportunity;
>
> I have 3 subforms but those seem to load fairly quickly when run
> individually (3-5 seconds).
>
>
> I've read, "Delete the SQL from the RecordSource and RowSource properties of
> the form, subforms, comboboxes and listboxes. Now in the Form_Load event load
> the appropriate SQL." I have three combo boxes, details to follow below.
> This may be the important piece I am missing only because I am confused on
> how to go about. If this is the culprit of my design could someone please
> help me with what the appropriate SQL that should be loaded on the Event page?
>
> Combo Box Details:
> Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
> Table/Query
>
> Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
> Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
> [Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source Type
> Table/Query
>
> Segment: Control Source Business_Segment/Row Source
> "Corp";"Mid";"Other"/Row Source Type Value List
>
> Please help. I hear grunts when people have to enter data into this database.
>
> Thanks!
 |  Next  |  Last
Pages: 1 2 3 4 5 6
Prev: How do I change the order that my records appear in in Forms
Next: Set Controls Default Value from another Control