number of records stored in Access tables

[Lifeseeker]

Hi,

Just have a question on the number of records that can be stored in an Access 2003 table.

Says table size: 2 gigabyte minus the space needed for system objects.

I'm using Access 2003, and what does 2 gigabyte translate into?

The table stores mostly text-based data.

Thanks

 

[boblarson]

Sorry, we can't answer that as it is very different depending on the different data you are storing and the number of fields and all. But it normally (if not using attachments or embedding images) can handle several million records at least, if not even more.