Limit to Access 2000 objects???

[tmorita]

Is there a limit to the amount of objects you put into a MDB?(forms,queries,linked tables and reports)

Thanks for the help.

 

[VBslammer]

Look in the help file under:

+--Setting up and Customizing Microsoft Access
    +--Microsoft Access Specifications

Here's a snippet:

Microsoft Access database general specifications

Attribute Maximum

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 (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
VBSlammer

Unemployed in Houston, Texas