U can always use linked tables in access to expand wat u need to store. it is a matter of design. When you use linked tables, the limit is your harddisk size.
Adrian Puchong, Malaysia --- ";-) jim" <[EMAIL PROTECTED]> wrote: > Well the practical limit is 1GB. You can corrupt > your Access DB if you hit the limit. > > Storing pictures inside a DB is not wise, save the > link to the picture. > > Oracle, SQL, MySQL are options. > > > ----- Original Message ----- > From: Jean-Pierre jamous > To: [EMAIL PROTECTED] > Sent: Sunday, November 07, 2004 11:07 PM > Subject: RE: [Visual Basic 6 programming] Maximum > Records per Table in Access > > > Out of curiosity, what would you do when you hit > 2GB? Migrate into Oracle? > I'd find this is a small size for a DB considering > that some DBs take > pictures if I am not wrong. > > -----Original Message----- > From: Rick Rose [mailto:[EMAIL PROTECTED] > Sent: Sunday, November 07, 2004 11:19 PM > To: [EMAIL PROTECTED] > Subject: Re: [Visual Basic 6 programming] Maximum > Records per Table in > Access > > > I don't know if there is a limit on the number of > records, but there is a > size limitation. The database can't be over 2 gb > in size. > > Rick Rose > -------Original Message------- > > From: drumric01 > Date: 11/07/04 21:50:03 > To: [EMAIL PROTECTED] > Subject: [Visual Basic 6 programming] Maximum > Records per Table in Access > > > Guys..anybody know how what's the maximum records > per table of an > Access Database?..thx > > > > > > > > Yahoo! Groups Links > > > > > > > > > . > > [Non-text portions of this message have been > removed] > > > > > > Yahoo! Groups Links > > > > > > > > > > > Yahoo! Groups Sponsor > > Get unlimited calls to > > U.S./Canada > > > > > ------------------------------------------------------------------------------ > Yahoo! Groups Links > > a.. To visit your group on the web, go to: > > http://groups.yahoo.com/group/visualbasic6programming/ > > b.. To unsubscribe from this group, send an > email to: > > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the > Yahoo! Terms of Service. > > > > [Non-text portions of this message have been > removed] > > __________________________________ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To reply to this message, go to: http://groups.yahoo.com/group/visualbasic6programming/post?act=reply&messageNum=17964 Please do not reply to this message via email. More information here: http://help.yahoo.com/help/us/groups/messages/messages-23.html <*> To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
