up vote 1 down vote favorite
share [g+] share [fb]

I have an access database that I gave to a user (shame on my head). They were having trouble with some data being too long, so I suggested changing several text fields to memo fields. I tried this in my copy and it worked perfectly, but when the user tries it they get a "Record is too large" messagebox on saving the modified table design. Obviously the same record is not too large in my database, why would it be in theirs?

link|improve this question
67% accept rate
1  
Are you and the user both using the same version of Access? Are you entering the EXACT same data into the field that they are? – JNK Jul 27 '10 at 12:29
@JNK Yes, same version. It's not when putting the data in that the problem occurs, but when changing the table design. – C. Ross Jul 27 '10 at 14:44
feedback

1 Answer

up vote 1 down vote

This question is fairly old but I just experienced this problem today and found a solution that may help others in the future.

The only thing I could do was to clear out all of the old records in the table before making a change to the table design. Even though none of the records seemed to be 'too large' they were preventing any updates to the table design.

Then only after saving the changes to the table will you be able to paste in the old information. When pasting the information back into the table you might get some errors on specific rows or fields that will help you narrow down the problem.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.