If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access queries among two databases
Hi There,
I am new to this group, so bear with me. I have three databases that were created by someone else, tracking expenses from 2004 2005 and now 2006. Using Access 2000 how can I link the various databases together so that I can run a report and query in the 2006 database and get data from 2005 and 2004 dbase. If some one can point me to instructions or respond to this post with them, it is appreciated. |
#2
|
|||
|
|||
Access queries among two databases
That someone else did you a major disservice. While you can link the various
database tables together, there's a very good chance that there will be nothing that will tell you if a record is from 2004 or 2006. Then you'll need to go through the same routine and make changes come 2007. Give it a try by opening up the database; go to File, Get External Data, Link Tables; then finding all the other needed tables in the other two databases. If they are named the same in all three databases, Access should put an _1 and _2 behind the linked tables. It will be up to you to keep track of which table is from what year. For a long term fix have the database rebuilt so that it can include the past and future years. Then carefully import in the existing data -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "sskenny" wrote: Hi There, I am new to this group, so bear with me. I have three databases that were created by someone else, tracking expenses from 2004 2005 and now 2006. Using Access 2000 how can I link the various databases together so that I can run a report and query in the 2006 database and get data from 2005 and 2004 dbase. If some one can point me to instructions or respond to this post with them, it is appreciated. |
Thread Tools | |
Display Modes | |
|
|