Tuesday, June 19, 2007
saAction
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
