Questions on a Database with Mass Data

  • Thread starter Thread starter AccessHelp
  • Start date Start date
A

AccessHelp

Good morning,

Currently, I have 5 databases with data (I would say, backend - BE
databases). Each database contains data for a specific year and has a size
of about 800 MB. The reason that I have 5 databases (represent 5 years of
data) is I don't think Access has a capability of handling 4 to 10 Gig of
data. Going forward, I will have more BE databases since I will have more
data for other years.

What I want to do is I want to build a frontend (FE) database that will
allow users to grab the specific data from a specific year (or multiple
years) by clicking a button or running a report. I know that I can link my
FE to each BE and let a query to grab the specific data from a specific year
(or multiple years). When I think of it and if I do that, I will end up
creating a lot of queries to grab the data. I don't think that is an
efficient way of doing it.

Please give me some advices or suggestions what you would do if you were me.
I also heard that SQL database can handle the massive data. Unfortunately,
I am not familiar with SQL database. If SQL database can do the job, please
let me know the sources where I can go to learn more about SQL databases.

Thanks.
 
Chris,

Thanks for the information.

Are you referring another db as SQL database? In order for me to use the
SQL server, how much involvement would I expect from our IT department? Is
SQL server a database that can store the data?

I am sorry I am new to the SQL server thing. Could you please tell me a
little bit more?

Thanks.
 
Back
Top