Moving data from one table to another (Cut and Paste?)

[Martiens]

Hi.

Is there an easy way to move data from one table to another?
I created a table to keep track of work that is requested and still outstanding. As soon as a request is complete there is a check box to check and the request is removed from the outstanding work.


We use this database on a server at work and with all the data in the table it gets kinda slow when more that one person is working on it at the same time.
Will it help if I create a new table (TBL_Archive) to store all the requests that are checked as Done and remove them from the main table (TBL_RequestLog) and is there an easy way to this with a button to basically "Cut and Pase" all checked requests from TBL_RequestLog to TBL_Archive so only the Unchecked requests remain in the main table?


Also, I already created a table (TBL_Archive) in the Back End on the server. How do I get that Table on my Front End now? Or should I just create it in my Front End and just Split the Database again?

Best Regards

[orange]

Please tell us more about your database set up. You mention "it gets kinda slow when more that one person is working on it at the same time"

If the database is split into Front end/back end , Does each user have a copy of the front end own their on PC?
What is your rationale for putting an Archive table on the backend and frontend?

Instead of cut and paste have you considered a StatusFlag in your table with values such as "Requested, In Progress, Completed" --just curious.

[Martiens]

Yes, its a split database with a front and back end.

The back end is on the server and the front end is on 5 different computers although there's only two people using it.
When one person is using the database (through his own front end) there's no problem. But as soon as two people use it simultaneously, whenever you add a new record or start to edit an existing record, the whole database Stops Responding for a short while and then starts working again. No real big problem but very annoying.

I decided to use a Check Box (Yes/No field) for when a request is complete or not and then just run a query to show only the records with the Yes/No field as False on a report that I print and give to my sub-contractor on a daily basis to go finish the work.

I just thought that it would be better to be able to move all the complete requests (Yes/No Field - True) to a separate table or "archive" in order to keep as little as possible data in my main table (TBL_RequestLog) namely all the incomplete requests, but still have all the records safely tucked away and there when I need it.

[orange]

But as soon as two people use it simultaneously, whenever you add a new record or start to edit an existing record, the whole database Stops Responding for a short while and then starts working again.

This tends to suggest something is wrong with the set up or some process.
All users are using same version of Access?
Each user has their own personal copy of the FE on their PC, right?
Here is a list of performance tips.

Perhaps someone else will comment/advise re the speed/delay issue.

Good luck