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
|
|||
|
|||
Slow form, again
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! |
#3
|
|||
|
|||
Slow form, again
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" wrote in message ... 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! |
#4
|
|||
|
|||
Slow form, again
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 "jenniferspnc" wrote in message ... 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! . |
#5
|
|||
|
|||
Slow form, again
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! |
#6
|
|||
|
|||
Slow form, again
"Steve" schreef in bericht ... 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. -- Get lost $teve. Go away... far away.... Again... Get lost $teve. Go away... far away.... No-one wants you here... no-one needs you here... This newsgroup is meant for FREE help.. No-one wants you here... no-one needs you here... OP look at http://home.tiscali.nl/arracom/whoissteve.html (Website has been updated and has a new 'look'... we have passed 11.500 pageloads... it's a shame !!) Arno R |
#7
|
|||
|
|||
Slow form, again
Are you doing this over a LAN, or over a WAN?
Is your form bound directly to the table, or to a query? And to how many rows? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "jenniferspnc" wrote in message ... 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! |
#8
|
|||
|
|||
Slow form, again
"Steve" wrote in message
... 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 Please do not feed the trolls! Stevie is our own personal pet troll who is the only one who does not understand the concept of FREE peer to peer support! He offers questionable results at unreasonable prices. These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. Please do not feed the trolls. John... Visio MVP |
#9
|
|||
|
|||
Slow form, again
RESUBMITTING because I can't see my own post...
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" wrote in message ... 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! |
#10
|
|||
|
|||
Slow form, again
Thanks everyone for the posts. I'll try to answer all the questions here.
It is over a LAN and the form is bound to a query. I put the BE two folders down (the closest I can get) and the name is short (Oppt_be). Each user has their own FE installed on their desktop. Yes, I do compact and repair often. Using Access 2007 Yes I actually thought of it and did take off one subform at a time trying to isolate the "problem." Removing all subforms gets the form to load in about 15 seconds. But removing only one at a time may only save me like 5 seconds (so with 3 that's about 15 seconds). Not sure if it is server related but this afternoon it was only taking 30 seconds to load vs this morning 40 seconds, and I hadn't made any changes to the original. If it's not my database I'm not sure what to tell my co-workers and boss for a solution. But it's taking too much time to enter information. Thanks for the FREE advice. Truly helps me learn instead of having someone else do it for me. "Jeff Boyce" wrote: Are you doing this over a LAN, or over a WAN? Is your form bound directly to the table, or to a query? And to how many rows? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "jenniferspnc" wrote in message ... 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! . |
Thread Tools | |
Display Modes | |
|
|