Prev: Text Field Size - Access 2007
Next: Any advice? Creating forms on the fly
From: Accesshelp on 6 Apr 2010 14:17
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 <--
> > > .
> > >
From: John W. Vinson on 6 Apr 2010 14:28
On Tue, 6 Apr 2010 10:04:17 -0700, Accesshelp
<Accesshelp(a)discussions.microsoft.com> 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.

It does have some real problems and limitations, but you might want to
consider MySQL. Access can work as a frontend to it, and the price is right.
--

John W. Vinson [MVP]
From: Accesshelp on 6 Apr 2010 15:02
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
> santus(a)penn.com
>
>
> "Accesshelp" <Accesshelp(a)discussions.microsoft.com> wrote in message
> news:059B7DA5-3385-432E-A052-843AB31C53F4(a)microsoft.com...
> > 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.
>
>
> .
>
From: Accesshelp on 6 Apr 2010 15:08
John,

Thanks for your response. How can I start MySQL?

"John W. Vinson" wrote:

> On Tue, 6 Apr 2010 10:04:17 -0700, Accesshelp
> <Accesshelp(a)discussions.microsoft.com> 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.
>
> It does have some real problems and limitations, but you might want to
> consider MySQL. Access can work as a frontend to it, and the price is right.
> --
>
> John W. Vinson [MVP]
> .
>
From: Accesshelp on 6 Apr 2010 15:14
John,

I am looking for a database that can handle at least 20GB (or between 20GB
and 100GB). As I mentioned in my previous message, I have a very limited
budget to create that database. Unfortunately, Access nor SQL Server Express
would not do the job due to their size limitations.

What would you suggest? Thanks.

"John W. Vinson" wrote:

> On Tue, 6 Apr 2010 10:04:17 -0700, Accesshelp
> <Accesshelp(a)discussions.microsoft.com> 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.
>
> It does have some real problems and limitations, but you might want to
> consider MySQL. Access can work as a frontend to it, and the price is right.
> --
>
> John W. Vinson [MVP]
> .
>
First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4 5
Prev: Text Field Size - Access 2007
Next: Any advice? Creating forms on the fly