Max number of fields in MSAccess

[Pauline Bennison]

Sorry but I am a newbie and this question is very basic.

What is the total number of fields I can have in a MS Access database.

Pauline

[ADezii]

I do believe the Maximum number of Fields you can have in any one Table is 255 and the Maximum number of 'Open' Tables is 2,048 (minus Internal Tables used by Access).

Microsoft Access Specifications

[youmike]

You could get round these limitations by designing a split system with multiple back ends, but the reality is that if you are up at those sorts of numbers, you really need to go back and ask yourself what you are really trying to do. Tables with 255 fields or a database with thousands of tables would in all likelihood be a maintenance nightmare!