Split Databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have two databases that I would like to pull information from both to
create reports. My question is this:

Could I somehow create a third database to hous the main table from the
other two so that as the information in the two main databases is being
inputted by the user, when a report is pulled from the third the information
will always be updated?

Thanks!!
 
You can create Linked Tables that point to the actual data. They will always
be current.

(You do this through File | Get External Data | Link Tables on the menu)
 
Thank you Douglas!

I do have one question though, by linking the two main tables like that,
will it disrupt the main tables in any way? In other words, will the two
databases perfom as they did before the linking and can I still modify those
databases(reports and so forth) without harming anything? Sorry, I am just
trying to be cautious as I never did anything like this before and hate to
run into a problem afterwards.

Thank you Sir for your help and Happy Thanksgiving!!
 
Yes. The tables in your other two DB's will not change at all. You'll
simply "tap" into them when running reports from your third.
 
Stockwell43 said:
Could I somehow create a third database to hous the main table from the
other two so that as the information in the two main databases is being
inputted by the user, when a report is pulled from the third the information
will always be updated?
Click to expand...

I'm confused as to the problem. A user enters/updates a record and
saves the changes the data should immediately be available on a
report. So I don't quite understand the problem.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top