Slow Database after splitting

[learningaccess]

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.

 

[Jeff Boyce]

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

 

[Tony Toews [MVP]]

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/

 

[learningaccess]

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.

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

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.

 

[Klatuu]

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

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.

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

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.

 

[learningaccess]

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.

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

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.

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

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.