Microsoft Access 2007 Specifications

Check Micorosft Access 2007 Specifications before you decided to create your your database in Access.

• Access database (.accdb) file size : 2 gigabytes,


• Number of objects in a database : 32768


• Number of modules : 1000


• Number of characters in an object name : 64


• Number of characters in a password : 20


• user name or group name : 20 characters


• Number of concurrent users : 255


• No. of characters in a table name : 64


• No. of characters in validation message : 255


• Table or field description : 255 characters


• Field property setting : 255 characters


• Number of joins in a query : 16(depands)


• Number of AND operators in a WHERE or HAVING clause 99(depands)


• Number of characters in an SQL statement Approximately 64000(depands)


• Number of characters in a label 2048 in report or form


• Number of characters in a text box 65535 in report or form


• Form or report width 22 in. (55.87 cm) only.


• Number of levels of nested forms or reports : 7


• Number of printed pages in a report : 65536


• Number of actions in a macro : 999

Thousands of developer have many ma