[MS_AccessPros] Move Data to another Table

 

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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 8
• New Files 6

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___