Maximun number of the records in MS Access

Hi, I would like to know how many records can be stored in the MS access? On some site, said that MS Access can store up to 65,000 records. Is that the maximun number or It can go beyond that number? Please help, and I will be appreciate a lot for your concern..

Way more than 65,000.

There is no explicit limit...Access 2000 and up has a file limit of 2GB,
which includes tables, records, forms, etc.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

"Nam" wrote in message
...
Hi, I would like to know how many records can be stored in the MS access?
On some site, said that MS Access can store up to 65,000 records. Is that
the maximun number or It can go beyond that number? Please help, and I will
be appreciate a lot for your concern..

On Mon, 7 Jun 2004 13:06:05 -0700, Nam
wrote:

Hi, I would like to know how many records can be stored in the MS access? On some site, said that MS Access can store up to 65,000 records. Is that the maximun number or It can go beyond that number? Please help, and I will be appreciate a lot for your concern..

The largest working Access database of which I am aware has one table
with 50,000,000 records. I'd have started looking into client server
at about 10,000,000 but it can be done.

I'd be curious what site has this misinformation. Are you sure it
wasn't referring to Excel?

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public