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 |
#11
|
|||
|
|||
Slow form, again
jenniferspnc,
Is the below query what the Parent form is based on? 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; ANd I could have missed it but I didn't see where you mentioned what version of Access... -- 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 ... 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! . |
#12
|
|||
|
|||
Slow form, again
Oops, guess I missed that question...I am running Access 2007.
Yes, that is the query for the parent form. I can post the code of the subforms if you think the problem might lie there. Thanks again "Gina Whipp" wrote: jenniferspnc, Is the below query what the Parent form is based on? 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; ANd I could have missed it but I didn't see where you mentioned what version of Access... -- 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 ... 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! . . |
#13
|
|||
|
|||
Slow form, again
jenniferspnc,
How big is this table... how many records? Seems a little slow at 15 seconds. Do you have any combo boxes on the Parent form any DLookups? And while you're at it can you post the code to the subforms? -- 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 ... Oops, guess I missed that question...I am running Access 2007. Yes, that is the query for the parent form. I can post the code of the subforms if you think the problem might lie there. Thanks again "Gina Whipp" wrote: jenniferspnc, Is the below query what the Parent form is based on? 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; ANd I could have missed it but I didn't see where you mentioned what version of Access... -- 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 ... 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! . . |
#14
|
|||
|
|||
Slow form, again
Jennifer:
One thing you can try is to make a copy of the BackEnd onto your local machine and see if that speeds things up. If it does then you know that it is the network that is slowing you down. Are you running SQL Server or Oracle on the BackEnd? I had a similar problem on a project that had Oracle on the BE and it was terrible slow. I converted all my Access SQL to pass-through SQL and the it sped up the application tremendously. The form load went from approximately 1-2 minutes down to a few seconds. HTH "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! |
#15
|
|||
|
|||
Slow form, again
?... and the number of rows/records you are trying to 'load'?
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 ... 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! . |
#16
|
|||
|
|||
Slow form, again
It has 19 records.
Subform1: SELECT tbl_countrybridge.CountryUniqueID, tbl_countrybridge.Country_ID, tbl_countrybridge.Opportunity_ID FROM tbl_countrybridge; Subform2: SELECT tbl_manufacturer.Manufacturer, Order_Parts.Opportunity_ID, Order_Parts.Unique_ID, Order_Parts.Country_ID, Order_Parts.Manufacturer_ID FROM Order_Parts LEFT JOIN tbl_manufacturer ON Order_Parts.Manufacturer_ID = tbl_manufacturer.Manufacturer_ID; Subform3: SELECT Opportunity_Type_List.Unqiue_Type_ID, Opportunity_Type_List.Type_ID, Opportunity_Type_List.Opportunity_ID FROM Opportunity_Type_List; ComboBox Details: 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 "Gina Whipp" wrote: jenniferspnc, How big is this table... how many records? Seems a little slow at 15 seconds. Do you have any combo boxes on the Parent form any DLookups? And while you're at it can you post the code to the subforms? -- 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 ... Oops, guess I missed that question...I am running Access 2007. Yes, that is the query for the parent form. I can post the code of the subforms if you think the problem might lie there. Thanks again "Gina Whipp" wrote: jenniferspnc, Is the below query what the Parent form is based on? 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; ANd I could have missed it but I didn't see where you mentioned what version of Access... -- 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 ... 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! . . . |
#17
|
|||
|
|||
Slow form, again
Yes, when I put the BE on my desktop it will open the form in about 3
seconds. So perhaps it's all network related? I'm not too sure about it being SQL or Oracle...not my area of knowledge. What do you suggest and how do I go about doing it? Thanks. "DrGUI" wrote: Jennifer: One thing you can try is to make a copy of the BackEnd onto your local machine and see if that speeds things up. If it does then you know that it is the network that is slowing you down. Are you running SQL Server or Oracle on the BackEnd? I had a similar problem on a project that had Oracle on the BE and it was terrible slow. I converted all my Access SQL to pass-through SQL and the it sped up the application tremendously. The form load went from approximately 1-2 minutes down to a few seconds. HTH "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! |
#18
|
|||
|
|||
Slow form, again
.... from your original post, about 20 records.
Loading a form with 20 records via a query, especially when that query has no calculated values or selection criteria or sort order, should appear instantaneous. If it still takes "3 seconds" when you have the data local on your PC, I'd be suspecting something else. 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. "Jeff Boyce" wrote in message ... ?... and the number of rows/records you are trying to 'load'? 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 ... 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! . |
#19
|
|||
|
|||
Slow form, again
Exactly what kind of network? (I am assuming the back end is an MDB, so
don't even concern yourself with Oracle or SQL Server.) -- 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 ... Yes, when I put the BE on my desktop it will open the form in about 3 seconds. So perhaps it's all network related? I'm not too sure about it being SQL or Oracle...not my area of knowledge. What do you suggest and how do I go about doing it? Thanks. "DrGUI" wrote: Jennifer: One thing you can try is to make a copy of the BackEnd onto your local machine and see if that speeds things up. If it does then you know that it is the network that is slowing you down. Are you running SQL Server or Oracle on the BackEnd? I had a similar problem on a project that had Oracle on the BE and it was terrible slow. I converted all my Access SQL to pass-through SQL and the it sped up the application tremendously. The form load went from approximately 1-2 minutes down to a few seconds. HTH "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! |
#20
|
|||
|
|||
Slow form, again
The back-end is a .accdb (using Office 2007).
Does that help?? Sorry IT is not my area "Gina Whipp" wrote: Exactly what kind of network? (I am assuming the back end is an MDB, so don't even concern yourself with Oracle or SQL Server.) -- 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 ... Yes, when I put the BE on my desktop it will open the form in about 3 seconds. So perhaps it's all network related? I'm not too sure about it being SQL or Oracle...not my area of knowledge. What do you suggest and how do I go about doing it? Thanks. "DrGUI" wrote: Jennifer: One thing you can try is to make a copy of the BackEnd onto your local machine and see if that speeds things up. If it does then you know that it is the network that is slowing you down. Are you running SQL Server or Oracle on the BackEnd? I had a similar problem on a project that had Oracle on the BE and it was terrible slow. I converted all my Access SQL to pass-through SQL and the it sped up the application tremendously. The form load went from approximately 1-2 minutes down to a few seconds. HTH "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! . |
Thread Tools | |
Display Modes | |
|
|