In addition to what John said, keepin glookup tables in the front end will be a nightmare every time a design change is made and you have to push out a new version. All the data in the local tables will either be lost or you will have to run a process to copy the data into the new front end.
I only use front end tables for things like local version numbers that are checkec against system version numbers to determine if the user has the latest version. Another table would be a preference table or a table to determine if the SQL tables were relinked when a design change was made to the SQL back end. SQL linked tables do not automatically pick up structure changes like linked Access tables do so you have to relink them.
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 Lorenzini <dbalorenzini@...> wrote:
>
> 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@...>
> 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]
>
Tidak ada komentar:
Posting Komentar