Split Databases

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!!
 
D

Douglas J. Steele

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)
 
G

Guest

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!!
 
G

Guest

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.
 
G

Guest

Hi Roger, you're a good man for the info., most appreciated.

Have a Happy Thanksgiving!!
 
T

Tony Toews [MVP]

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?

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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top