Max number of fields in a table

  • Thread starter Thread starter misssy
  • Start date Start date
M

misssy

What is the maximun number of fields (columns) that can be
in an Access table?
 
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)
 
Hi

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

Immanuel Sibero
 
You must log in or register to reply here.

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

Max. number of Tables 6
Maximun number of fields in a pivottable in excel 2007? 2
How to subtract a number from a Mergefield? 0
15 numbers in a cell 1
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Access Dcount (multiple criteria) 3
ASP.NET and Access as online database? 7
Limit on number of fields in MS Access forms 3

Back
Top