Record is to Large error

[Fadius]

This error is new to me. What causes this and any suggestions on how to correct it?

My users get this error on a couple record where they want to add data to a field.

Thank you in advance for any suggestions.

 

[mcfaddea]

Hi
Had an error of this description before, but would need more info about yours before being able to offer correct advice.

Alan

 

[Fadius]

I am using Access 97 running on WIndows NT 4.0. Other than that, what other information would you be looking for?

 

[mcfaddea]

Record data type, max reqd size, etc.

Two things come to mind
1- String of characters you are entering is greater than 255 (MS predefined max length) This can be altered in the properties. Or greater than a length you may have changed it too. I got caught out here before as when setting properties accidentally removed a 5 and only gave my text box max length of 25.

2- Your users are attempting to use a stretched text box for data entry where a memo field would be more beneficial

 

[bobjackson]

I have had a similar problem,

Do you have alot of fields in the table or alot of large fields.

My problem reporting the same error was due to the number and size of fields in the main table.

When I setup all the different fields it was not a problem. It was only when the users starting populating the fields that the error occurred.

It was okay for quite some time untill more and more of the fields became populated.

I carried out the following to eradicate the problem.

1) Analyse all field sizes and reduce sizes if possible.
2) Consider using abbreviations in fields if possible.
3) Assess the requirement of all fields.
4) Consider splitting of the table. i.e. I found that I could break out 25 fields that were relevant to the Datasheet No. and put these in a seperate table.

I had the error two months ago and at the time was getting it regularly since rationalising I have not had the error again.

Let me know how you go on. Never smile at work, they may think you're enjoying yourself too much and cut your pay.

 

[Fadius]

I do have a very large number of fields and all are text fields with there size limit set to 255. I will try reducing the field size on as many of them as possible and will let you know how it works.


Thanks.