Obviously, you need to go with MySQL if you cannot buy one of the regular
editions of SQL-Server.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)


"Accesshelp" wrote in message
...
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.


.



.