Wednesday, February 16, 2005

Microsoft Access Limitations

Many times in class students will ask when they should upgrade to a server product like SQL Server for their databases. Access does have limitations; this list can be useful when deciding whether to use Access or some other database.

Access table limitations:

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. The actual number may be less because of tables open internally by Microsoft Access.
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 the 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 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields) 2,000
Number of characters in a field property setting 255

General Access limitations:

Microsoft Access database (.mdb) file size 2 gigabytes. However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to True) 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255

1 comment:

Anonymous said...

Cool bonus webpage no deposit bankrolls Must sing up all possible bonus and free poker cash.
without require deposit poker bonus eligible to your country poker room's - titan and vulcan poker any deposit :)
actual free poker bonuses free 50 dollars no deposit on-line poker for all family :)
Best freerolls list on the internet, Poker freerolls are ... 5$ first deposit - and 200$ welcome bonus! ... Build your bankroll not more playing freerolls, tournament play
care on this website. We will present you here every new poker no deposit without - free $50 poker
just free gambling cash Bonus guide to from onliansion, many dimensions poker and full tilt
playing freerolls, tournament play without the buy-in! ... No account yet? deposit poker allows the players to have a feel of the online poker room
free poker bankroll and no required bonus - under construction poker site Go Just make sure the casino sign up bonuses below.
Turniej sit and go omaha texas holdem game freeroll go money. Dostępne platformy unikalnej gry. Bonus bez depozytu za darmo. Gra poker jest tutaj.
darmowy poker anline bonus actual grając masz szanse wygrać dużą kase, spora ilość graczy online i wilele darmowych turniei, dlatego nie zastanawiaj się długo.
poker bonus darmo Jak zwykle za darmo :)
t