Max records in Access 2000 table?

P

Phil Stokes

What is the maximum no of records allowed in an access
database table? I'm sorry if this is rather basic question
but I have been unable to find the answer anywhere.

Thanks, Phil
 
A

Adrian Jansen

Look in Help, specifications.

There is no specific number of records limit, only a max size, 1Gb for A97,
2Gb for A2000 and up.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
C

Cheryl Fischer

There is no effective maximum number of records allowed in a table. Access
2000 (as well as 2002 and 2003) has a database size limit of 2GB which may
be composed of a single table object or multiple objects.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Regarding Word Add in on Office 365 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
ASK Field Formatting 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Is this possible? 0

Top