too many fields defined

How many?
If it really is too many then normalize the dB

In Access 97 it was 255 fields!

hi terry. It is to late to normalize the db, the db is in use. Can I connect to tables together or do you have an other solution?

Are you saying that you do have more than 255 fields?

You can make another table where you can store the extra fields. Make the primary Key a long int. Then on the form where you enter the data you can have these fields in a sub form which is linked to the main form through its primary key which is more than likely an autonumber and the new primary key.

Im not to happy to admit that I have used 255 fields, because i know what you are thinking about this matter. But I did.
I am thinking......

:o)
Well the only soultion I can come up with Jan is what I have already suggested. But I would also suggest you try normalizing it.

I tried to delete 10 fields and added 7 but i still get this message 'too many fields defined' do you know where to reset the counter of fileds?

I did compact and repair, then i succeed to add my new fields, but I had to delete some fields :-(

I dont think you can ZERO the field counter. Access has field definitions in its own tables so can count what there is.