Number of fields in a table or query

[nqobile]

My table is to have 212 fields but my access 2000 keeps saying I have define too many fields once I reach the 124th field. I ended up splitting the table into two,with the hope of creating a make table query that will bring them together. It still wont work.
NB: tables and queries take a maximum of 255 fields.

What could be the problem?

 

[cheerio]

Access 2000 help under the heading:

Microsoft Access database table specifications

Number of characters in a record (excluding Memo and OLE Object fields) 2,000

So you are probably hitting the maximum record size.

Generally, very high numbers of fields in a record indicates that the database structure has not been normalised.

Ken