Question

Access database management

Database, Microsoft Access, Database programming

Hi guys
I am managing a database and need to know if there is away of moving 'completed' records into another database but keep them linked.

Senario is: We have records of pieces of work coming into the office and which take about amonth to complete the cycle.
My query is instead of having this database then filling up with completed and uncompleted records, how would you move the completed lines into a second databse, yet have it linked?

I would think i would need part of it that states eg 'Record Complete' where would input a 'Y' to signify this. Then what would i need to do to move that line into a second database for completed records?

Any suggestions or solutions from others that have similar projects much appreciated.


Tim Anderson

Simply link the table (Get External Data - Link) from the history database into your current database. Say the table in current is Work and you would link WorkHistory from the history database. Now both databases are in you main application database. Then as the work is compelete, you could make an append query to append the records from the Work table to the WorkHistory table and then a delete query to delete the records from the Work table. You could make a union query called AllWork like this: Select * from Work Union Select * from WorkHistory. Now when you access that query for example in a report or look up form, you will have all records - both current and history.