Invalid (?) Error Messages - Any Ideas?

R

russi

Registered User.
Local time
Today, 21:52
Joined
Jul 18, 2000
Messages
385
Hi. I have a database containing various linked tables and all has been fine for years.
I now have to add some fields to the main table and change some field sizes. I know about the 255 field limit. And I know that an individual record cannot exceed 2K.

BUT, when I simply lower the size of a text field, (i.e., from 40 to 30), I get either the message Too Many Fields Defined or Record Is Too Large.

Ideas???
 
Wayne,

Thanks for the suggestion that I will try.

Meanwhile, if I close compact the table after each 1 or 2 changes, than it is okay. Otherwise, not. A real pain.

Russ
 
Have you tried importing all the items into a new blank database? If you reach the maximum number of fields, controls, etc. over the life of the database (and it keeps track), you will get to a place where you can't go any further, even though you don't actually HAVE the maximum allowed.

Try creating a blank database and import all of the objects and see what that does for you.
 
Thanks for the info.

I did not know that it kept track of 'evereything' over a database's life, if you did regular compacting.

Russ
 
Yes, it's something that isn't logical and shouldn't be, but that's Microsoft for you.
 
I agree about Microsoft, but...

I still need help!

Russ
 
You must log in or register to reply here.

Similar threads

P
Record Too Large error message
Replies
5
Views
570
GPGeorge
GPGeorge
D
Solved Query if Between lower and upper to return lower, returning all records
Replies
9
Views
499
dullster
D
B
Form sizing / scrolling for smaller screens
Replies
9
Views
775
isladogs
isladogs
MajP
Multi value Fields (MVF) Various Topics
Replies
0
Views
556
MajP
MajP
Cliff67
Solved Another Run-time Error '2465'
Replies
8
Views
845
Cliff67
Cliff67

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom