cannot change field size

[russi]

Hi.
I have a main table (with other tables related to it).
It has the 255 max number of fields. (I know... But bear with me.)

ANyway, I need to change some field's size to smaller sizes. But if I try to change them, even 1 at a time, I get the cannot do because I have too many fields defined.

Ideas???

Russ

 

[Jibbadiah]

Maybe you could try something like:
- Copy the table
- Delete one column in the copied table
- Make your adjustments to the copied table
- Paste the extra column back in to the copied table.
- Delete original table.
- Rename copied table to original table name.

** Obviously back up the whole database first.

If that doesn't work, try a make table query that only selects the first 254 columns and then repeat the above process.

 

[russi]

Thanks, so much!

I tried your 1st idea and it worked!

Russ