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 Database after splitting
I've read through the information posted at
http://www.granite.ab.ca/access/performanceforms.htm but have some questions. After splitting the database it takes close to a minute to open a form with subform. I saw where it says to "Delete the SQL from the RecordSource and RowSource properties of the form, subforms, comboboxes and listboxes..." So I go to the RecordSource of my form and give the query a name. Then I delete the record source and go to the load event on the form. I type in Private Sub Form_Load() Me.RecordSource = "Form 2 Query" End Sub I've done that for every form but that's not helping, thinking I've missed a lot, but considering I'm not that familiar with Access I’m struggling…it still takes 40 seconds to open a query. I also saved the backend at the very beginning of the path instead of going through 7 folders. Any detailed suggestions? I figure I still need to do some things to the forms, but again, very unfamiliar territory. Appreciate the help. |
#2
|
|||
|
|||
Slow Database after splitting
Did the particular query (?[Form 2 Query] ... which isn't very informative a
title) fill the form more quickly before the split? Does that query run very quickly on its own (i.e., to open the dataset, not to fill the form)? When you say "split" and I say "split", we may not be referring to the same thing. What do you mean by it? Provide a more detailed explanation. For instance, is the data still in an Access .mdb (or .accdb), or is it now in SQL-Server or ...? Describe the network configuration. More info, please! Regards Jeff Boyce Microsoft Office/Access MVP "learningaccess" wrote in message ... I've read through the information posted at http://www.granite.ab.ca/access/performanceforms.htm but have some questions. After splitting the database it takes close to a minute to open a form with subform. I saw where it says to "Delete the SQL from the RecordSource and RowSource properties of the form, subforms, comboboxes and listboxes..." So I go to the RecordSource of my form and give the query a name. Then I delete the record source and go to the load event on the form. I type in Private Sub Form_Load() Me.RecordSource = "Form 2 Query" End Sub I've done that for every form but that's not helping, thinking I've missed a lot, but considering I'm not that familiar with Access I'm struggling.it still takes 40 seconds to open a query. I also saved the backend at the very beginning of the path instead of going through 7 folders. Any detailed suggestions? I figure I still need to do some things to the forms, but again, very unfamiliar territory. Appreciate the help. |
#3
|
|||
|
|||
Slow Database after splitting
learningaccess wrote:
I've read through the information posted at http://www.granite.ab.ca/access/performanceforms.htm but have some questions. After splitting the database it takes close to a minute to open a form with subform. I saw where it says to "Delete the SQL from the RecordSource and RowSource properties of the form, subforms, comboboxes and listboxes..." If you have a simple form and subform then these aren't required. However if you had say five or six subforms then these steps become more useful. The tips on that page are in suggested priority. Have you done the first three or four steps such as keeping a bound form or recordset open at all times? I also saved the backend at the very beginning of the path instead of going through 7 folders. One or two folders down are reasonable enough. Seven folders deep certainly isn't so you've done the right thing there. T -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ |
#4
|
|||
|
|||
Slow Database after splitting
Yes, all my forms/queries opened within a second before splitting the
database to a FE/BE. Yes the Form 2 Query is not a proper name, was just used for saving the query built in the record source, then removing the record source, and calling the query through the load event of the form, and testing to see if that made a difference. If it had helped I was going to go through the steps of associating the querys with the form name, but it didn't seem to make a difference. That article is probably a bit above my head so I'm not sure what other adjustments I can do to the form and or query to make it move quicker. By splitting I mean the database is still in Access .mdb. Now when I go to the shared drive, where the BE resides, it only takes about 5 seconds to open the folder holding the BE so I don't think it's a network thing. On a side note, I did turn off name auto correct and copy the turn of datasheets code into a module in the BE and ran it. I do thank you for your time in trying to help sort this out. Manager is wanting this to go live today and will not be happy with the speed issue. "Jeff Boyce" wrote: Did the particular query (?[Form 2 Query] ... which isn't very informative a title) fill the form more quickly before the split? Does that query run very quickly on its own (i.e., to open the dataset, not to fill the form)? When you say "split" and I say "split", we may not be referring to the same thing. What do you mean by it? Provide a more detailed explanation. For instance, is the data still in an Access .mdb (or .accdb), or is it now in SQL-Server or ...? Describe the network configuration. More info, please! Regards Jeff Boyce Microsoft Office/Access MVP "learningaccess" wrote in message ... I've read through the information posted at http://www.granite.ab.ca/access/performanceforms.htm but have some questions. After splitting the database it takes close to a minute to open a form with subform. I saw where it says to "Delete the SQL from the RecordSource and RowSource properties of the form, subforms, comboboxes and listboxes..." So I go to the RecordSource of my form and give the query a name. Then I delete the record source and go to the load event on the form. I type in Private Sub Form_Load() Me.RecordSource = "Form 2 Query" End Sub I've done that for every form but that's not helping, thinking I've missed a lot, but considering I'm not that familiar with Access I'm struggling.it still takes 40 seconds to open a query. I also saved the backend at the very beginning of the path instead of going through 7 folders. Any detailed suggestions? I figure I still need to do some things to the forms, but again, very unfamiliar territory. Appreciate the help. |
#5
|
|||
|
|||
Slow Database after splitting
Where is the FE?
If it is on the network, this can have a negative impact on performance. Each user should have a copy of the FE on their own computer. -- Dave Hargis, Microsoft Access MVP "learningaccess" wrote: Yes, all my forms/queries opened within a second before splitting the database to a FE/BE. Yes the Form 2 Query is not a proper name, was just used for saving the query built in the record source, then removing the record source, and calling the query through the load event of the form, and testing to see if that made a difference. If it had helped I was going to go through the steps of associating the querys with the form name, but it didn't seem to make a difference. That article is probably a bit above my head so I'm not sure what other adjustments I can do to the form and or query to make it move quicker. By splitting I mean the database is still in Access .mdb. Now when I go to the shared drive, where the BE resides, it only takes about 5 seconds to open the folder holding the BE so I don't think it's a network thing. On a side note, I did turn off name auto correct and copy the turn of datasheets code into a module in the BE and ran it. I do thank you for your time in trying to help sort this out. Manager is wanting this to go live today and will not be happy with the speed issue. "Jeff Boyce" wrote: Did the particular query (?[Form 2 Query] ... which isn't very informative a title) fill the form more quickly before the split? Does that query run very quickly on its own (i.e., to open the dataset, not to fill the form)? When you say "split" and I say "split", we may not be referring to the same thing. What do you mean by it? Provide a more detailed explanation. For instance, is the data still in an Access .mdb (or .accdb), or is it now in SQL-Server or ...? Describe the network configuration. More info, please! Regards Jeff Boyce Microsoft Office/Access MVP "learningaccess" wrote in message ... I've read through the information posted at http://www.granite.ab.ca/access/performanceforms.htm but have some questions. After splitting the database it takes close to a minute to open a form with subform. I saw where it says to "Delete the SQL from the RecordSource and RowSource properties of the form, subforms, comboboxes and listboxes..." So I go to the RecordSource of my form and give the query a name. Then I delete the record source and go to the load event on the form. I type in Private Sub Form_Load() Me.RecordSource = "Form 2 Query" End Sub I've done that for every form but that's not helping, thinking I've missed a lot, but considering I'm not that familiar with Access I'm struggling.it still takes 40 seconds to open a query. I also saved the backend at the very beginning of the path instead of going through 7 folders. Any detailed suggestions? I figure I still need to do some things to the forms, but again, very unfamiliar territory. Appreciate the help. |
#6
|
|||
|
|||
Slow Database after splitting
The FE is on my desktop and the BE is on the network (shared) drive. I've
not given any copies of the FE to users yet as I'm trying to resolve speed issues. Thanks. "Klatuu" wrote: Where is the FE? If it is on the network, this can have a negative impact on performance. Each user should have a copy of the FE on their own computer. -- Dave Hargis, Microsoft Access MVP "learningaccess" wrote: Yes, all my forms/queries opened within a second before splitting the database to a FE/BE. Yes the Form 2 Query is not a proper name, was just used for saving the query built in the record source, then removing the record source, and calling the query through the load event of the form, and testing to see if that made a difference. If it had helped I was going to go through the steps of associating the querys with the form name, but it didn't seem to make a difference. That article is probably a bit above my head so I'm not sure what other adjustments I can do to the form and or query to make it move quicker. By splitting I mean the database is still in Access .mdb. Now when I go to the shared drive, where the BE resides, it only takes about 5 seconds to open the folder holding the BE so I don't think it's a network thing. On a side note, I did turn off name auto correct and copy the turn of datasheets code into a module in the BE and ran it. I do thank you for your time in trying to help sort this out. Manager is wanting this to go live today and will not be happy with the speed issue. "Jeff Boyce" wrote: Did the particular query (?[Form 2 Query] ... which isn't very informative a title) fill the form more quickly before the split? Does that query run very quickly on its own (i.e., to open the dataset, not to fill the form)? When you say "split" and I say "split", we may not be referring to the same thing. What do you mean by it? Provide a more detailed explanation. For instance, is the data still in an Access .mdb (or .accdb), or is it now in SQL-Server or ...? Describe the network configuration. More info, please! Regards Jeff Boyce Microsoft Office/Access MVP "learningaccess" wrote in message ... I've read through the information posted at http://www.granite.ab.ca/access/performanceforms.htm but have some questions. After splitting the database it takes close to a minute to open a form with subform. I saw where it says to "Delete the SQL from the RecordSource and RowSource properties of the form, subforms, comboboxes and listboxes..." So I go to the RecordSource of my form and give the query a name. Then I delete the record source and go to the load event on the form. I type in Private Sub Form_Load() Me.RecordSource = "Form 2 Query" End Sub I've done that for every form but that's not helping, thinking I've missed a lot, but considering I'm not that familiar with Access I'm struggling.it still takes 40 seconds to open a query. I also saved the backend at the very beginning of the path instead of going through 7 folders. Any detailed suggestions? I figure I still need to do some things to the forms, but again, very unfamiliar territory. Appreciate the help. |
Thread Tools | |
Display Modes | |
|
|