Go Back   TechArena Community > Software > Tips & Tweaks
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 29-01-2010
Member
 
Join Date: Nov 2009
Posts: 1,075
Tips to improve subform performance in Access.

Actually I am working on the software project. My instructor has said that the performance of your software depends on the data base design of your software project. I have tried my level best to design the data base as good as possible. But it will be better if my sub form perform better. So need to know the tips for improving the performance of subform in Access.
Reply With Quote
  #2  
Old 29-01-2010
Member
 
Join Date: Apr 2008
Posts: 598
Re: Tips to improve subform performance in Access.

I will like to mention some of the tips for improving the performance subform in Access.
1. It will better if you design your subform on the bases of queries rather than designing on the bases of tables.
2. Do not include the extra fields from the record source it will be better if you include the most important fields. Because the extra record will decrease the subform performance.
3. It will be better if you index all the fields in the subform that have a link to main form.
4. Indexes help to improve the performance.
Reply With Quote
  #3  
Old 29-01-2010
Member
 
Join Date: Apr 2008
Posts: 395
Re: Tips to improve subform performance in Access.

I will give you the tips with the help of an example.
If you want to link multiple fields, then adding a calculated field to the main form that will concatenate the fields. After that create a calculated column for the subforms.
For example, to link to the subform on an Customer ID field and an Category ID field, add a text box to the main form with the following properties:
Name: CustomerIDCategoryID
ControlSource: =[CustomerID] & [CategoryID]
Next, add the following field to the query that the subform is based on:
CustomerIDCategoryID: [Customer ID] & [Category ID]
Finally, link the main form and the subform on the concatenated field rather than on the two individual fields. The subform properties may appear as follows:
LinkChildFields: CustomerIDCategoryID
LinkMasterFields: CustomerIDCategoryID
Because Microsoft Access has to compare only one criteria to return the subform's recordset, the subform's performance should improve.
Reply With Quote
Reply

  TechArena Community > Software > Tips & Tweaks
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Tips to improve subform performance in Access."
Thread Thread Starter Forum Replies Last Post
Tips to improve form performance in Visual Studio 2010 Mahajabeen Tips & Tweaks 2 31-01-2010 04:39 AM
Tips to improve performance in SQL server and ODBC. Florence_USA Tips & Tweaks 3 29-01-2010 05:18 AM
Access 2007 subform not refresh avvia Windows Software 2 13-07-2009 11:49 AM
MS Access - How to filter subform Zariah Windows Software 3 05-06-2009 05:27 PM
Form SubForm ACCESS 2007 streetprods Software Development 2 30-05-2009 03:18 PM


All times are GMT +5.5. The time now is 09:12 AM.