advanced microsoft access training london - tables ma

Forum home » Delegate support and help forum » Microsoft Access Training and help » advanced microsoft access training london - Tables in MA

advanced microsoft access training london - Tables in MA

resolvedResolved · Low Priority · Version Standard

Brian has attended:
Access Intermediate course
Access Advanced course

Tables in MA

Is there a maximum limit to the amount of tables Access can hold? Additionally is there a limit to the fields a table can hold?

RE: Tables in MA

Hello Brian,

Thanks for the question, Looking through my books I can only find partial answers to your question, What I have found relates to Access 2000, Max database size = 2GB, Max TableSize = 1GB, Max number of objects in a database = 32,768, Max number of modules in a database = 1000, Max number of fields in a table = 255. Hope that helps.


 

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips


Server loaded in 0.08 secs.