|
Access databases have considerable scaleability, vastly in excess of many small business database needs.
Access is capable of storing tables up to 2 Gigabytes however, because your database can include linked tables in other files, its total size is limited only by your machines available storage capacity.
For more detailed program specifications please see below:
Access database general program specifications
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 1,000
Number of concurrent users 255
Access database table specifications
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
Access database query specifications
Number of enforced relationships 32 per table minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships
Number of tables in a query 32
Number of fields in a recordset 255
Recordset size 1 Gigabyte
Form and report specifications
Number of characters in a label 2048
Number of characters in a text box 65,535
Number of printed pages in a report 65,536
Access and SQL reserved words
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | R | S | T | U | V | W | Y |
ADD
ALL
ALTER
AND
ANY
AS
ASC
AUTOINCREMENT
AVA
BETWEEN
BINARY
BIT
BOOLEAN
BY CREATE
BYTE
CHAR
CHARACTER
COLUMN
CONSTRAINT
COUNT
COUNTER
CURRENCY
DATABASE
DATE
DATETIME
DELETE
DESC
DISALLOW
DISTINCT
DISTINCTROW
DOUBLE
DROP
EXISTS
FROM
FLOAT
FLOAT4
FLOAT8
FOREIGN
GENERAL
GROUP
GUID
HAVING
INNER
INSERT
IGNORE
IMP
IN
INDEX
INT
INTEGER
INTEGER1
INTEGER2
INTEGER4
INTO
IS
JOIN
KEY
LEFT
LEVEL
LIKE
LOGICAL
LONG
LONGBINARY
LONGTEXT
MAX
MEMO
MIN
MOD
MONEY
NOT
NULL
NUMBER
NUMERIC
OLEOBJECT
ON PIVOT
OPTION PRIMARY
ORDER
OUTER
OWNERACCESS
PARAMETERS
PERCENT
REAL
REFERENCES
RIGHT
SELECT
SET
SHORT
SINGLE
SMALLINT
SOME
STDEV
STDEVP
STRING
SUM
TABLE
TABLEID
TEXT
TIME
TIMESTAMP
TOP
TRANSFORM
UNION
UNIQUE
UPDATE
VALUE
VALUES
VAR
VARBINARY
VARCHAR
VARP
WHERE
WITH
YESNO
| 