Selasa, 19 Juli 2011

Re: [MS_AccessPros] Move Data to another Table

 

Thank you I will try that.

Celeste

--- In MS_Access_Professionals@yahoogroups.com, "Gary D. Schwartz" <gary.schwartz@...> wrote:
>
> One thought:
>
> Instead of linking directly to the data table in the backend db,
> create a filtered query in the backend to link to from your frontend.
> Essentially, the backend will prefilter to show only active records.
> You could have a second query (the one you use now) in the frontend
> that still goes to the original table if you need occasional access
> to inactive records.
>
> This should speed things up, or at least simplify the routine access
> to the active records.
>
> Gary
>
>
> At 04:45 PM 7/15/2011, you wrote:
> >I have a split database. The backend is on a server and everyone
> >copies the frontend to their local hard drive.
> >
> >The main data table has 4600 records in it with at least 100 being
> >added each month.
> >
> >When the database is queried, it is slow because it is searching all
> >the records.
> >
> >Some of the records are "closed" are there for reference only.
> >
> >Would it be wise to take those records out the DataTable 1 and put
> >them in a new table just in case someone needs to see them at a later date?
> >
> >Looking for suggestions,
> >
> >Thank you,
> >Celeste
>
>
> --------------------------------------------------------
> Gary D. Schwartz Please reply to: gary.schwartz@...
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar