Re: MS Access Row Limit

["Jim Franz" <franz400@xxxxxxxxxxxx>]

http://www.databasezone.com/techdocs/acclimit.html
try this

jim franz

----- Original Message ----- 
From: "Mark Allen" <allenmar@xxxxxxxxx>
To: "PC Technical Discussion for iSeries Users" <pctech@xxxxxxxxxxxx>
Sent: Friday, February 10, 2006 10:31 PM
Subject: Re: [PCTECH] MS Access Row Limit


> 2G used to be the limit on the size of the .mdb, it may be or going to be 
> 4 now, so # of rows depends on # of columns,lengths, etc I beleive
>
> Mark Villa <iseries.4.me@xxxxxxxxx> wrote: I remember it being deep in the 
> doco somewhere. 1,000,000 but I do not know
> when or if that was expanded. The thought being, they wanted you to upsize
> it.
>
> On 2/10/06, Joe Giusto II  wrote:
> > Is there a limit to the number of rows in an MS Access database table.  I
> > have
> > been searching and can't find any reference to maximum rows or row
> > limit.  I am
> > hoping that is because there is not a limit.
> >
> >
> > --
> > This is the PC Technical Discussion for iSeries Users (PcTech) mailing
> > list
> > To post a message email: PcTech@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/pctech
> > or email: PcTech-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/pctech.
>
>
>
> --
> Mark Villa
> Summerville, SC
> --
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing 
> list
> To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech.
>
>
>
>
>    Mark Allen
>  allenmar@xxxxxxxxx
>  Home: 859 635 5980
>
>
>
>
> ---------------------------------
> Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on 
> new and used cars.
> --
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing 
> list
> To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech.