Home....
Developer Network >> Other Programming >> Database

Maximum limit for MS-Access

I want to know what is the maximum capacity of MS-Access to hold records.
I am creating a database which consists of around 10,000 records. Will Access support it. My frontend application is Visual Basic 6.0
[211 byte] By [cmrhema] at [2007-11-20 4:44:13]
«« Updating XML File using XSLT
»» FindWindow
# 1 Re: Maximum limit for MS-Access
I would say 10,000 is not a huge number for Access.

For other limits and specifications related to MS-Access, take a look at
http://www.databasedev.co.uk/access_specifications.html
Shuja Ali at 2007-11-9 13:44:46 >
# 2 Re: Maximum limit for MS-Access
If U are not forced to use Access than consider changeing it to relational server (SQL2005 Expressf or example). It will spare U a few problems in the future. Access capacity limits are the limits that are, by theory, possible to reach, but not a limmits that guarantee that application will bahave correctly ;).

Best regards,
Krzemo.
Krzemo at 2007-11-9 13:45:47 >
# 3 Re: Maximum limit for MS-Access
Hi all.

As Shuja Ali said, 10000 records aren't a big amount of data for Access.
Nevertheless, consider that Access shows some problems in multi-user applications.
davide++ at 2007-11-9 13:46:45 >
Other Programming
Database

Other Programming

All Classified

Other Programming New Topic

Other Programming Hot Topic