Thank you, Crystal. Since Access sets up subdatasheets for you without you knowing, it can be a real pain. Make sure you turn of Name AutoCorrect Tracking before you even start building tables or the sub datasheets will pop back up when you compact.
Bill
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> great tip, Bill! ... I generally set all Sub Datasheets to "none" in the beginning and turn off AutoCorrect, so I forget that others don't ...
>
> Happy Friday :)
>
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
>
>
> ________________________________
> From: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Friday, April 6, 2012 8:59 AM
> Subject: [MS_AccessPros] Re: Streaming lining the size of a back end database
>
> One more thing to do to your back end (although it won't have a big impact since you are not opening the back end much) is to set all Sub Datasheets to "none". Sub datasheets are like mini sub forms on a table. They can show child records for a given record in the parent table by clicking on the + to the left of the record (if the sub datasheet was set up).
>
> The problem with them is that they add a lot of overhead to big tables. When you open a table in datasheet view all those extra fields have to load, too.
>
> To turn them all off in all tables run my code found on my site at:
> http://thatlldoit.com/codesamples.aspx#anchor4
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@> wrote:
> >
> > I know there is probably a lot of tips on on how to boost the performance of a backend database but could you give me like the top 5.
> >
> > Right now I am going back through and removing all the lookups I had built into the tables and using combos on the form do the work. What else could I look at?
> >
> > I know this is a wide and varied topic but any help would be great.
> >
> > Thank you,
> >
> > Arthur Lorenzini
> > Sioux Falls, SD
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar