Access database management
Home > IT Answers > Database > Access database management
Timanderson
5 pts.
0
Q:
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
ASKED: Aug 21 2008  8:30 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Randym
1410 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Aug 21 2008  2:25 PM GMT by Randym   1410 pts.
Latest Contributors: Jaideepkhanduja   7010 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Squashjunkie   325 pts.  |   Aug 21 2008  2:42PM GMT

To give you a good view of what is happening to your records, you would be better adding the following fields to your “working” database
1. A status i.e. N=New Record, I=Incomplete, C=Complete
2. A user stamp - I assume that you have user logins in your database that you can record when a transaction line / record is updated.
3. A date/time stamp - the last date/time that the record was updated.

Using these three in addition to the above will give you greater management over which records need to be updated, and also enhance your ability to track and filter data.

 
0