Slow Load Time After Splitting - Re Tony's Code

[Nate via AccessMonster.com]

Hello all

Can anyone explain exactly how to speed up load time after splitting it? I
have read many posts about this site:
http://www.granite.ab.ca/access/performanceforms.htm

He gives instructions, but they arn't very clear to me as I am a beginner.
For example I'm not sure what he means by:
"Delete the SQL from the RecordSource and RowSource properties of the form,
subforms, comboboxes and listboxes". How do you do this??

Additionally I am not sure how to use the code he gives for the load event.
DO I need to create a query for a table I have? (qryLargeTable) I am
assuming I need to edit the code to fit my database, Im just not clear as
to how. This is the code he gives:

Private Sub Form_Load()
Me.RecordSource = "qryLargeTable"
Me.txtSomeField.RowSource = _
"SELECT SomeField " & _
"FROM qryLargeTable " & _
"GROUP BY SomeField " & _
"ORDER BY SomeField;"
End Sub

Then in the Unload event he suggested this:
Private Sub Form_Unload(Cancel As Integer)
Me.RecordSource = ""
Me.cboFindRecord.RowSource = ""
End Sub

My DB is in Access 2000 and I used the Splitting utility to split my
database. I split it in the network folder, and then copied the FE to my
desktop. I am assuming I did this correctly.

Any help is much appreciated
Thanks
Nate

 

[Allen Browne]

Nate, I suggest that if you do not understand what Mark Plumpton is saying
here, that you are best ignoring those issues and focusing on other ones.

His idea is to open the form in design view, and delete the form's
RecordSource property (in the Properties box, available through the View
menu), and to also delete the RowSource property of any combos or list boxes
on the form. Then programmatically assign these values in the Load event of
the form. There are advantages and disadvantages of this approach, and the
timing values Mark gives would not necessarily apply to A2002 or A2003.

The most crucial issues are the ones Tony lists in this page:
http://www.granite.ab.ca/access/performancefaq.htm
Particularly, if you set the Name AutoCorrect options off and set the
SubdatasheetName to [None] for each table, you should find that those two
things alone make the database workable.