Max number of fields in a table

B

Bas Cost Budde

misssy said:
What is the maximun number of fields (columns) that can be
in an Access table?
Click to expand...

-- oh, if you are *anywhere* near that number, chances are that your
design needs review. The subject to browse is 'normalisation' (or with a
z, that depends)
 
I

Immanuel Sibero

Hi

255 but rarely do you need anywhere close to that number.

Immanuel Sibero
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximun number of fields in a pivottable in excel 2007? 2
Max. number of Tables 6
Limit on number of fields in MS Access forms 3
Trying to reduce number of fields 0
ASP.NET and Access as online database? 7
Populating Fields Automatically 2
Dynamic generation of a table 3
User-defined Outlook fields in Access 2

Top