Stephen,

I have a set of data with minimum of 10GB. I have tried breaking up the
data into multiple back-end Access databases. When I tried to run a query on
those data from a front-end Access database. I could not because Access is
limited to 2GB. The same is with SQL Express, and it limits to 4GB.

Thanks.

"Stephen Raftery" wrote:

I cannot help wondering whether you really need such an enormous database
with a singel user.
Can you give us any hints as to what this database does?

Stephen


"Steve" wrote:

How do you know you need 20GB right now?

What do you mean by "data and query expansion"?

Steve


"Accesshelp" wrote in message
...
Steve,

Thanks for your response. I do not need 100GB at this moment. I will,
however, need it in the future. For now, I need around 20GB for data and
query expansion.

Thanks.

"Steve" wrote:

How do you know you need 100GB?

Steve



"Accesshelp" wrote in message
...
Hello all,

I am sure this place is a right place to ask questions on SQL Server.

I want to create a SQL Server, and I do not know how to get started. I
have
tried 2003 SQL Server Express, and it did not work for me due to the
limit
of
database size at 4GB. 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. I will have SQL Server as a back-end database and
Access
as
a front-end database. I also may want to access the SQL Server from
Access
FE in a laptop computer.

If you can share with me how I can get started and how much it will
cost
me,
I would be greatly appreciated.


.



.