Microsoft Access 2007 file size limits

[avvia]

I know the file size limit for Access 2003 is 2 gb. We can include maximum 64 characters in a table name. Is that same for Microsoft Access 2007? What is file size limit for Microsoft Access 2007. Any recommendations and suggestions are appreciated.

[JonathanD]

File size limit for Microsoft Access 2007 database is 2 gigabytes. Although the maximum size for a single database file is 2GB, you can work around this limitation by using a split database. A front-end database file can point to thousands of back-end database files, each of which could be as large as 2GB.

For more information : http://office.microsoft.com/en-us/ac...307391033.aspx

[Glenny]

Microsoft access size limit is same for both access 2003 and access 2007. It give 2 gb of size limit for single database file. You can create 32,768 object and 1000 character of each module that you have created. You can give 64 character while defining the name of object.

[ThoMas321]

Specification :
Microsoft Access database (.mdb) file size 2 gigabytes minus the space needed for system objects.
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