Size Limits for latest versions

Hi,

Sorry if this a repetitive question. I looked for an FAQ and
didn't find one and Microsoft's website, as usual, is coy about
product limitations.

I've read that earlier versions of Access had a 2GB databse
size limit and need to know if this has changed in AccessXP
or Access2003? I don't think it has but promised the boss
I double-check.

TIA for your help,

Gerry Murphy

re: Size Limits for latest versions

On Mon, 24 May 2004 22:51:10 -0400, "Gerry Murphy"
<gerrymurphy@rcn.com> wrote:

No.
If you need more, look at SQL Server or its light cousin MSDE which
ships with Access.

-Tom.

[color=blue]
>Hi,
>
> Sorry if this a repetitive question. I looked for an FAQ and
>didn't find one and Microsoft's website, as usual, is coy about
>product limitations.
>
> I've read that earlier versions of Access had a 2GB databse
>size limit and need to know if this has changed in AccessXP
>or Access2003? I don't think it has but promised the boss
>I double-check.
>
> TIA for your help,
>
> Gerry Murphy
>[/color]

re: Size Limits for latest versions

On Mon, 24 May 2004 22:51:10 -0400, "Gerry Murphy"
<gerrymurphy@rcn.com> wrote:

No.
If you need more, look at SQL Server or its light cousin MSDE which
ships with Access.

-Tom.

[color=blue]
>Hi,
>
> Sorry if this a repetitive question. I looked for an FAQ and
>didn't find one and Microsoft's website, as usual, is coy about
>product limitations.
>
> I've read that earlier versions of Access had a 2GB databse
>size limit and need to know if this has changed in AccessXP
>or Access2003? I don't think it has but promised the boss
>I double-check.
>
> TIA for your help,
>
> Gerry Murphy
>[/color]

re: Size Limits for latest versions

Tom van Stiphout <tom7744@no.spam.cox.net> wrote:
[color=blue]
>If you need more, look at SQL Server or its light cousin MSDE which
>ships with Access.[/color]

MSDE also has the same 2Gb size limit.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

re: Size Limits for latest versions

Tom van Stiphout <tom7744@no.spam.cox.net> wrote:
[color=blue]
>If you need more, look at SQL Server or its light cousin MSDE which
>ships with Access.[/color]

MSDE also has the same 2Gb size limit.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

re: Size Limits for latest versions

On Tue, 25 May 2004 05:41:07 GMT, Tony Toews <ttoews@telusplanet.net>
wrote:

True. But at least it can be used while the db is in development
and/or filled with data. Once you get close to the 2GB mark, indeed
upgrading to the Standard Edition is the only option. Your app will
likely work unchanged.

-Tom.

[color=blue]
>Tom van Stiphout <tom7744@no.spam.cox.net> wrote:
>[color=green]
>>If you need more, look at SQL Server or its light cousin MSDE which
>>ships with Access.[/color]
>
>MSDE also has the same 2Gb size limit.
>
>Tony[/color]

re: Size Limits for latest versions

On Tue, 25 May 2004 05:41:07 GMT, Tony Toews <ttoews@telusplanet.net>
wrote:

True. But at least it can be used while the db is in development
and/or filled with data. Once you get close to the 2GB mark, indeed
upgrading to the Standard Edition is the only option. Your app will
likely work unchanged.

-Tom.

[color=blue]
>Tom van Stiphout <tom7744@no.spam.cox.net> wrote:
>[color=green]
>>If you need more, look at SQL Server or its light cousin MSDE which
>>ships with Access.[/color]
>
>MSDE also has the same 2Gb size limit.
>
>Tony[/color]