Access 2003 - database file limit

Hi,

I was wondering if the database file size limit was still 2GB in
Access 2003? Does anyone out there who has been beta testing or a mvp
have any info on this?

Regards

Mike

Mike,

The brief answer is No, you can go to the sky in Access 2003, but my
experience is that Access gets flakey when you get that high, especially if
you are adding a large number of records between Compact/Repair cycles.

Hope this helps.

Gary


"Mike" <mike_kenyon@tiscali.co.uk> wrote in message
news:732403d0.0309260117.684bd11a@posting.google.c om...[color=blue]
> Hi,
>
> I was wondering if the database file size limit was still 2GB in
> Access 2003? Does anyone out there who has been beta testing or a mvp
> have any info on this?
>
> Regards
>
> Mike[/color]

"Gary Floam" <floam@comcast.net> wrote:
[color=blue]
>The brief answer is No, you can go to the sky in Access 2003, but my
>experience is that Access gets flakey when you get that high, especially if
>you are adding a large number of records between Compact/Repair cycles.[/color]

I would've thought that given A2003 is using Jet 4.0 it still has the 2 Gb
limitation.

http://support.microsoft.com/default...en-us%3B302524 states

Database
file size: 2 gigabytes minus the space needed for system objects

and at the bottom:

The information in this article applies to:
Microsoft Office Access 2003
Microsoft Access 2002

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