Visual Basic Programmer

Visual Basic Programmer

Access Database Programmer.
Visual Basic.Net Programmer.
Microsoft Office Programmer.


VB Programing support
Access Database
Microsoft Office
VB.Net & SQL Server




nev@NevVB.com.au



Ring me for Visual Basic and Access programming
Sydney, Australia
(02) 9453-0456




Contact Details



28/01/2012

Microsoft Access Database Programmer

Access 2003 and Access 2007 Database Limits

Visual Basic Programmer: Microsoft Access 2007 The general limitations between Access 2003, Access 2007 and Access 2010 are unchanged.

Note that the following are theoretical limits. For example, the 255 maximum number of users bears no relationship to reality. Microsoft Access is unlikely to be able to support more than 10 concurrent users.

Object Item Limit
Access Database File size 2 Gigabytes
  Number of objects 32,768
  Number of Modules 1,000
  Number of users 255
Table Table Name 64 characters
  Field Name 64 characters
  Number of fields 255
  Text fields 255 characters
  Memo field 65,535
  OLE Object field 1 Gigabyte
  Number of indexes 32
  Number of records Limited by File size
Queries Number of Tables 32
  SQL statement 64,000 characters
  Number of ANDs 99

Home Page         Next Page