Size and growth of Access database
From: Joe Pettit (joep_at_i-f-s.com)
Date: 11/28/03
- Next message: Fabio Dell'Aria: "Re: Strange error "Connection failure" happens from time to time in my web application"
- Previous message: Martin Banser: "access and blanks"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 28 Nov 2003 12:03:45 -0500
I remember seeing / reading about that Access tables have a maximum size of
2 Gigs, is that still true? Does it depend on the OS?
If it is true, is there a formula to determine about how many records can be
placed in an Access table before the 2 Gig limit is reached. For the sake
of simplicity assuming the database has just 1 table in it and I know the
size of a record. Is it simply :
maxrecords := 2 Gig / recsize
For example my record can be :
ID : integer (size 2)
Name : char [50]
Description : char[100]
Date : date; (size 4)
So my record size is 156. maxrecords := 2 Gig / 156 .
Thanks for any help, Joe
- Next message: Fabio Dell'Aria: "Re: Strange error "Connection failure" happens from time to time in my web application"
- Previous message: Martin Banser: "access and blanks"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
