Tables

[Guest]

Does anyone know how many fields are allowable in a table? I am working on designing a database for our lab to use in environmental testing and when I created the table, it told me that I had to many fields. Anyone know a way to get around this?

 

[Gary]

It's 255, and has been since at least Access 97.

-----Original Message-----
Does anyone know how many fields are allowable in a

table? I am working on designing a database for our lab
to use in environmental testing and when I created the
table, it told me that I had to many fields. Anyone know
a way to get around this?

 

[Van T. Dinh]

255 Fields in the current session. This means that if you have 255 Fields
then delete 10 Fields, Access still thinks you have 255 Fields.

However, 255 Fields is usually about at least 5 times more than the max.
number of Fields you need for Tables in a properly designed and implemented
database using the Relational capability of the database engine.

If you get this error, perhaps you should find out about Relational Database
Design Principles and Database Normalisation and check whether your Table
Structure is correct.

--
HTH
Van T. Dinh
MVP (Access)

Does anyone know how many fields are allowable in a table? I am working

on designing a database for our lab to use in environmental testing and when
I created the table, it told me that I had to many fields. Anyone know a
way to get around this?