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

[manoj]

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/

 

[Jerry Whittle]

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.