Reports From 2 Databases

[DS]

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

 

[Rick Brandt]

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.

 

[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

 

[Rick Brandt]

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.

Number of Records is not the issue. Only the size of the file. With some
records several millions would not be a problem. With others you could be in
trouble a lot sooner than that. I would not want to store data in an MDB much
beyond 500MB (even though the actual limit is 2GB).

I only brought it up because many people have very small notions of how much
data an Access file can hold or they mistakenly believe that the more data you
have the slower your application gets. The latter is only true when your
database is not structured properly.

If you really are separating your files to avoid very large files then it is
probably a good idea. Myself, I would probably move to a server database where
I could have it all in one database without worrying about it.

 

[DS]

Number of Records is not the issue. Only the size of the file. With some
records several millions would not be a problem. With others you could be in
trouble a lot sooner than that. I would not want to store data in an MDB much
beyond 500MB (even though the actual limit is 2GB).

I only brought it up because many people have very small notions of how much
data an Access file can hold or they mistakenly believe that the more data you
have the slower your application gets. The latter is only true when your
database is not structured properly.

If you really are separating your files to avoid very large files then it is
probably a good idea. Myself, I would probably move to a server database where
I could have it all in one database without worrying about it.

Hi Rick,
I thought about going to a server database but it sounds like it's a lot
Maintance,(So I've Heard) Also I pretty much have the whole thing
written already and at this point don't want to start again. What I
have should work for the smaller places, but the basketball arena is
what I'm concerned about...thats about three years down the road, so if
I do change I have time to rewrite.
The way it is now reports will be run on a daily, weekly and monthly
basis and I thought that it would be better to have the data out of the
way, so to speak, from the current data that is being input daily. when
you say structered properly, do you have any guidelines for that? Once
again thank you for your input and help.
DS

 

[Rick Brandt]

Hi Rick,
I thought about going to a server database but it sounds like it's a lot
Maintance,(So I've Heard) Also I pretty much have the whole thing written
already and at this point don't want to start again. What I have should work
for the smaller places, but the basketball arena is what I'm concerned
about...thats about three years down the road, so if I do change I have time
to rewrite.
The way it is now reports will be run on a daily, weekly and monthly basis and
I thought that it would be better to have the data out of the way, so to
speak, from the current data that is being input daily. when you say
structered properly, do you have any guidelines for that? Once again thank
you for your input and help.
DS

I just mean properly normalized tables and proper use of indexes. With that in
place the amount of data has a minimal effect on speed. Without them and size
makes a huge difference.

 

[DS]

I just mean properly normalized tables and proper use of indexes. With that in
place the amount of data has a minimal effect on speed. Without them and size
makes a huge difference.

Thank You, Rick
DS