Table fields

[mallinarc]

Having 143 fields in a table is a problem in Access 2000?

i was trying to create 144 th field and i get a message saying too many fields. How to get arround with it without breaking the table?

mallinarc

 

[dcx693]

I don't know of any built-in limitation, but that doesn't mean there's no practical limitation. Why do you need that many fields in your table? Can you explain the structure of your data?

 

[mallinarc]

First this table is the source to the tabed form, so i can't break this table since it is the source table.

In the form user enters the values of the meter readings. There are huge no. of buildings/readings and additional info. on each electric meter.

The Access Specification says there is a limit of 255 fields.

I have only 143 fields in the table it should allow me.

Mallinarc

 

[dcx693]

Sounds like your data is not structured "correctly" in a normalized table. I would suggest something like having one buildings table that keeps information in each building, then having a meter reading table that just keeps meter readings. So the data would look something like this:

Building table
BuildingID
Address


Readings table
BuildingID
Date
Reading

Some sample data might be this:

Building table
1  1313 Penny Lane
2  456 Pound Drive

Readings table
1  7/21/2003  10
1  7/20/2003  9
1  7/19/2003  5
2  7/21/2003  20
2  7/20/2003  15

etc