How many records access can handle??

[hello101]

Hi,

Can someone tell me how many records can access 2002 handle?

Thank you

 

[traingamer]

1 gigabyte per table. If you spread tables through linking - a whole lot.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Golom]

There is no "number of records" limitation. The limits that do exist are

[li]The size of the mdb file cannot exceed 2 Gb[/li]
[li]The size of a table cannot exceed 1 Gb[/li]