Rabu, 11 April 2012

Re: [MS_AccessPros] Re: Streaming lining the size of a back end database

 

Any opinons on keeping lookup tables with the client and keeping the primary table in the backend?

With warm regards,

Arthur Lorenzini
Sioux Falls, South Dakota

________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, April 6, 2012 9: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
>

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar