Thread
:
Questions on SQL Server
View Single Post
#
16
April 8th, 2010, 06:40 AM posted to microsoft.public.access.tablesdbdesign
Sylvain Lafontaine[_2_]
external usenet poster
Posts: 247
Questions on SQL Server
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.
.
.
Sylvain Lafontaine[_2_]
View Public Profile
View message headers
Find all posts by Sylvain Lafontaine[_2_]
Find all threads started by Sylvain Lafontaine[_2_]