Prev: Having problems with Combo Box (Form Control)
Next: String formatting question
From: gls858 on 19 Jan 2010 14:57
forest8 wrote:
> Hi there
>
> I have an access table that has about 255 columns.
>
> Several fields need to be adjusted to a Yes/No instead of its current
> setting of text.
>
> When I try to change it, I get a "Too many fields defined" message that pops
> up.
>
> Followed by "Errors were encountered during the save operation. Data types
> were not changed. Properties were not updated."
>
> What is the best way to resolve this?
>
> Thank you in advance.
>
>

While this doesn't address your current situation, you may want to take
a look at Question Pro. We used it here for a while and price wise it's
reasonable. Might be a better tool for the job.

http://www.questionpro.com/

I don't work for them or benefit from their sales yada yada. Just liked
their program.

gls858
From: Tom Lake on 19 Jan 2010 15:11

"forest8" <forest8(a)discussions.microsoft.com> wrote in message
news:EC4D0A43-3DA2-4331-BF39-0C6A8F1D5B9A(a)microsoft.com...
> Hi there
>
> I have an access table that has about 255 columns.
>
> Several fields need to be adjusted to a Yes/No instead of its current
> setting of text.
>
> When I try to change it, I get a "Too many fields defined" message that pops
> up.
>
> Followed by "Errors were encountered during the save operation. Data types
> were not changed. Properties were not updated."
>
> What is the best way to resolve this?
>
> Thank you in advance.
>
>

You'd have to delete a field and pack the database before you could add another field.
Changing a field type is like adding a new field, copying the data from the old field
and then deleting the old field. You can't do that when you already have 255 fields.

You might try writing a make table query that creates a new table with half the fields
from the original table, delete the copied fields from the original table, then relate the
two
tables in a one-to-one relationship.

Tom Lake

First  |  Prev  | 
Pages: 1 2 3
Prev: Having problems with Combo Box (Form Control)
Next: String formatting question