Access queries among two databases

  • Thread starter Thread starter sskenny
  • Start date Start date
S

sskenny

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.
 
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
 
Back
Top