Stephen,

Thanks for your response. I have tried using several back-ends with Access,
and it would not work. The problem is when I run a query to pull the data
from multiple back-ends, Access creates a temporary file in a Temp folder.
When the temporary file hits 2GB, the query stops running.

I did the same with SQL Express, and it happened to me the same when it hit
4GB.

Thanks.

"Stephen Raftery" wrote:

If you are the sole user, then Access may well be the right way to do it.
Your need for 100G of data seems strange - why so big?
If necessary, you could have one front-end file, and several back-end files,
each of which has a 4G limit. Would that work?

Stephen


"Accesshelp" wrote:

Hi Stefan,

Thanks for your response.

As far as number of users, I will the only user; however, the data will be
at least 10GB before expansion.

I will use it for personal. Therefore, I have a very limited budget.

Unfortunately, Access nor SQL Express would not do the job due to size of
data.

Thanks.

"Stefan Hoffmann" wrote:

hi,

On 06.04.2010 17:09, Accesshelp wrote:
I am sure this place is a right place to ask questions on SQL Server.
You should ask this question in one of the microsoft.public.sqlserver.*
groups.

I need a database with at least 100GB capacity.
My current plan is to buy a $500 desktop computer for the purpose of
hosting
the SQL Server.
While such a computer can handle such a database, the question is 'How
will it perform?'. So what kind of database is it, how many concurrent
users do you have, how much I/O is involved?

If you can share with me how I can get started and how much it will cost me,
I would be greatly appreciated.
$500 + license fee for SQL Server 2008 Standard...


mfG
-- stefan --
.