Current location: Hot Scripts Forums » Other Discussions » Database » Maximum Limits of Microsoft Access Database

Maximum Limits of Microsoft Access Database

Reply
  #1 (permalink)  
Old
digioz's Avatar
Community VIP
 
Join Date: Oct 2003
Location: Chicago, IL
Posts: 2,178
Thanks: 3
Thanked 59 Times in 11 Posts
Maximum Limits of Microsoft Access Database

I got this excellent question from "airprince" through a PM message, and I thought it would be good to share it on the forum publically:


Hello,

Microsoft Access by design was not designed to be used for such large size storage of data or to keep a large number of records. By default, there is a 2GB maximum file size on a mdb file, and a 32768 maximum number of objects that can be stored in it. If you are thinking of having 100,000 records in a ms access database, I would recommend against it.

Here are some more interesting statistics for your information:

Attribute - Maximum
-----------------------------------------
Number of characters in a table name: 64
Number of characters in a field name: 64
Number of fields in a table: 255
Number of open tables: 2048 - Actual max is less, since access opens some by default
Table size: 1 gigabyte
Number of characters in a Text field: 255
Number of characters in a Memo field: 65,535 when entering data through user interface; 1 gigabyte when entering data programmatically.
Size of an OLE Object field: 1 gigabyte
Number of indexes in a table: 32
Number of fields in an index: 10
Number of characters in a validation message: 255
Number of characters in a validation rule: 2048
Number of characters in a table or field description: 255
Number of characters in a record (excluding Memo and OLE Object fields): 2000
Number of characters in a field property setting: 255


Pete

Quote:
Originally Posted by airprince
Greetings......

I just want to ask aboust Visual Basic.

I am developing a Program using Visual Basic. This program needs MS Access for data storage. Everyday more than hundred of data added in the Database. If the data reaches 100,000 or more, does it affect the performance of the program? I mean will it run as is or will run slow especially when finding records on the database?

I dont have much idea about Basual basic. I only read some tutorials here and downloaded some sample code.

in fairness I learned some basic and maybe some hard codes. Just for reading and reading some of your samples.

Thanks
__________________
Reply With Quote

Featured Marketplace Scripts (view more)

  #2 (permalink)  
Old
Guest
 
Posts: n/a
Thanks for posting that, I have seen it some where before but it is good information. Personlay I would not use access if the database is larger than 500 MB, especialy with sql 2005 express available. I thought it can handle more than 100,000 records per table, but I still would not do it.
Reply With Quote
  #3 (permalink)  
Old
digioz's Avatar
Community VIP
 
Join Date: Oct 2003
Location: Chicago, IL
Posts: 2,178
Thanks: 3
Thanked 59 Times in 11 Posts
Yeah, people seem to forget that Microsoft Access was meant to be more of a personal / single user database then anything else.
__________________
Reply With Quote
  #4 (permalink)  
Old
Community VIP
 
Join Date: Jan 2006
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
People should also take into consideration the number of simultaneous users. Access is considered unstable after about 5.
__________________
my site
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
deploying multiple form application that uses Access database lschafer Windows .NET Programming 5 04-20-06 04:00 PM
Streaming Video Access & Database Management Control ClearVision Script Requests 0 03-16-05 01:46 AM
Asp and Microsoft Access 2002 problem gop373 ASP 2 10-06-04 09:13 AM
Connection woth Access database? Sniper4u3 HTML/XHTML/XML 2 09-24-04 03:27 AM
2 questions 1-Webbased database access. 2-PDF data retrieval Mehre PHP 1 04-11-04 04:20 AM


All times are GMT -5. The time now is 12:27 PM.
vBulletin® Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.