Re: Split Databases

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

"Douglas J. Steele" wrote:

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)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Stockwell43" <Stockwell43@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4A0E7E4B-F60F-4BA5-ACFA-A4D785600146@xxxxxxxxxxxxxxxx
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!!



.

Relevant Pages

  • Re: Split Databases
    ... (You do this through File | Get External Data | Link Tables on the menu) ... I have two databases that I would like to pull information from both to ... create reports. ... Could I somehow create a third database to hous the main table from the ...
    (microsoft.public.access.formscoding)
  • Re: WHY
    ... That sort of thing is built into modern spreadsheets but not databases. ... If there were no conversion fees reflected in the conversion rates, ... And no one uses supercomputers of clusters for generating reports. ...
    (microsoft.public.excel)
  • Re: WHY
    ... push dfata into a spreadsheet; ... It is impossibly to have adequate field validation in Excel... ... >>If you mean reports, then I don't disagree that databases could be more ...
    (microsoft.public.excel)
  • Re: WHY
    ... it's a question of who's generating the reports. ... databases do most of their data entry into character mode applications ... Beleive me, if it could be, Microsoft would be pushing it like you wouldn't ... Microsoft has *NEVER* been shy about marketing anything it thinks will ...
    (microsoft.public.excel)
  • Re: why>?
    ... easier to do in a spreadsheet than it is to do in Excel. ... I can produce portable reports in PDF form quite easily.. ... Spreadsheets are poor platforms for writing complex ... databases don't NEED to store a different formula for each row. ...
    (microsoft.public.excel)