If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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..
|
#2
|
|||
|
|||
Maximun number of the records in MS Access
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.. |
#3
|
|||
|
|||
Maximun number of the records in MS Access
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 |
Thread Tools | |
Display Modes | |
|
|