how many records(max) can be inserted in a table

[Guest]

HI,,

I am asked in an interview,,

can u tell the maximum number of records and fields can be stored or typed
in a table..

Kindly do help me and post the answe..

Thanks in advance
Manoj

 

[Jeff Boyce]

Check Access HELP for "specifications"

(note that this is a "where to find out" response, rather than a "here is
the answer" response...)

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Joseph Meehan]

HI,,

I am asked in an interview,,

can u tell the maximum number of records and fields can be stored or
typed in a table..

Kindly do help me and post the answe..

Thanks in advance
Manoj

There is no max number of records. The max size of the total database
is 1 or 2 gig depending on the version. This and many other fun facts are
in the help file. It will tell you if you have a 1 or 2 gig limit.

 

[Guest]

Fields: 255
Records: 133 million and change. Of course these 133 million records are
totally useless as it's just one field populated by 1 character. For a
usefull database, probably around 2 or 3 million records without large memo
fields or OLE objects.