Re: Reports From 2 Databases

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

Rick Brandt wrote:
"DS" <bootybox@xxxxxxxxxxxxx> wrote in message news:s_gah.696$tp6.415@xxxxxxxxxxxxxxx

I keep all of my Sales Info in A seperate Database called History.mdb I want to run a report from my main Database called Current.mdb. I'll be using some tables from both. First is this possible? Or do I have to import just what I need back into the Current.mdb. If so how would I pull just the desired records back into main. I wouldn't pull them back into the regular tblChecks and tblCheckDetails tables but I would create a tblOldChecks and tblOldCheckDetails to run the reports and then delete the records. So I guess my questions are do I need to pull the info back/ If not how would I run the report? If yes, once again how would I run the report.
Thanks
DS


File
Get External Data
Link Tables

By the way unless you are talking HUGE amounts of data there is no good reason not to keep all your data in one database.

It depends on what you mean by huge amounts of Data...I have small places, about 100 entries a day, and huge places, (How many people does a basketball arena hold?) about 10,000 to 70,000 entries a day. So does this qualify.
Thans
DS
.

Relevant Pages

  • RE: updated numbers in report
    ... for making an input to the database. ... textbox will be located alongside with the combobox where the belonging ... belonging query for the report. ... ElapsedTime([Date First Time Onboard], ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Creating a report entirely through code
    ... In my case this is a very simple database, ... >> thus greatly increase the probability of corruption. ... >> button doesn't gray out after a compile, a control starts to ... >>>report and not a form where they have to enter data in. ...
    (microsoft.public.access.formscoding)
  • Re: Creating Access DB
    ... database and in the SQL database that your report needs. ... click the query tab. ...
    (microsoft.public.excel.programming)
  • Re: MSSQL$SBSMonitoring Database size (SBS2003)
    ... You can use the SQL Client Utilities to try and shrink the database. ... to delete over 90 day old information from the monitoring ... The server will start to collect new counter value ... Check 'View the usage report in Server Management' option. ...
    (microsoft.public.windows.server.sbs)
  • Re: Suggestion
    ... Datamarts allow you to create summarized data and improve the query response ... You have to choose the better source regarding the report you have to ... Detailed information can query your OLTP data sources. ... >> Keeping the historical vs. current data partitioned by database is ...
    (microsoft.public.sqlserver.datawarehouse)