Forum home » Delegate support and help forum » Microsoft Access Training and help » access vba courses in london - Numbers of fields/tables

access vba courses in london - Numbers of fields/tables

ResolvedVersion Standard

Mon 26 Nov 2007, 08:25 Delegate Jo said...

Jo has attended:
Access Introduction course

Numbers of fields/tables

Is there a maximum number of fields you would recommend for a table or maximum number of tables for a database?

Thanks

Jo

Mon 26 Nov 2007, 09:37 Trainer Richard said...

RE: Numbers of fields/tables

Hi Jo

Thanks for your question about Microsoft Access tables and fields.

The maximum number of fields that you can have in an Access table is 255.

Regarding the number of tables you can have in a database, Ms Access has a maximum of 32,768 OBJECTS that can be in any one database. You can divide that number into tables, queries, forms, reports.

If you have any further questions about Access, please post your questions to the forum.

Regards

Richard
Microsoft Office Specialist