Field Size Limit Error Messages

  • Thread starter Thread starter Simon Dowse
  • Start date Start date
S

Simon Dowse

Hi,

Am running Access 2000 and when I try and increase the
number of characters allowed in a text field I am getting
a message which says:

'Too Many Fields Defined'

So I click on 'OK' and then receive the following:

'Errors were encountered during the save operation. Data
types were not changed'

Any ideas what can be done to avoid this!
 
Mmmm...not sure and can't be bothered to count because
Compact and Repair worked a treat...Many thanks!
 
Mmmm...not sure and can't be bothered to count because
Compact and Repair worked a treat...Many thanks!
Click to expand...

Can't be bothered to count? You have that many fields, then? Say, how
many? Over 20 usually signals some design flaw.

Unless, of course, you don't want to change the design...
 
OK...if it takes that long to count the columns, you may very well be
dealing with a table that is not properly designed, which might mean you
will be back later asking for help in other areas....

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Kevin3NF said:
OK...if it takes that long to count the columns, you may very well be
dealing with a table that is not properly designed, which might mean you
will be back later asking for help in other areas....
Click to expand...
Icy... ;-)
 
Back
Top