maximum table size

[JeroenNL]

Hi there,

We have a very large Access 2003 database both in terms of filesize and number of records. One table has over 11 million records and we are wondering when/if it's going to be too much.

I read somewhere that 1 Access table can be up to 1 gigabyte in size. Is this correct?

If so, I can calculate the amount of bytes 1 record needs and as such calculate how big the table is and how many more records it can still hold.

Bye,
Jeroen

Bye,
Jeroen

A 3d level editor in Delphi

http://www.gamefortress.com/~delgine

 

[BNPMike]

If you're talking about the Jet database here, then you can easily pick up the maximum size from Google. What I would say is the size a Jet database takes up has to be calculated from the data not the the field sizes. Text fields only take the space of what's actually stored not what you have specified.