If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Number of Tables Limitation
What is the limitation on the number of tables that an Access 2007 database
can contain? -- PCGrammy |
#2
|
|||
|
|||
Number of Tables Limitation
On Mon, 8 Jun 2009 16:08:02 -0700, PCGrammy wrote:
What is the limitation on the number of tables that an Access 2007 database can contain? Why do you ask? The Help for Specifications might be useful; for one thing it says that you're limited to 32768 objects (tables, forms, reports, macros, modules) in the table, which should be plenty. If your database design includes large numbers of tables, particularly large numbers of *identically structured* tables, your structure needs to be reconsidered. A database with over a hundred tables is a BIG database (and yes, I've worked with bigger databases); one with tens of thousands of tables is probably not correctly structured (but still possible with Access if you insist). -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Number of Tables Limitation
Thanks so much for your timely and informative reply.
-- PCGrammy "John W. Vinson" wrote: On Mon, 8 Jun 2009 16:08:02 -0700, PCGrammy wrote: What is the limitation on the number of tables that an Access 2007 database can contain? Why do you ask? The Help for Specifications might be useful; for one thing it says that you're limited to 32768 objects (tables, forms, reports, macros, modules) in the table, which should be plenty. If your database design includes large numbers of tables, particularly large numbers of *identically structured* tables, your structure needs to be reconsidered. A database with over a hundred tables is a BIG database (and yes, I've worked with bigger databases); one with tens of thousands of tables is probably not correctly structured (but still possible with Access if you insist). -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|