Why can't I change a data type in an Access table?

[trainer07]

I am trying to change the data type in one of my tables. I do it every month
and it works fine. This month I am getting an error message that says it
can't change the data type because "There isn't enough disk space or memory".
Any assistanve would appreciated.
Thanks!

 

[pietlinden]

I am trying to change the data type in one of my tables. I do it every month
and it works fine. This month I am getting an error message that says it
can't change the data type because "There isn't enough disk space or memory".
Any assistanve would appreciated.
Thanks!

You change the structure of your database every month? That's a BAD
idea. Why not just use a query to convert from one type to the other
CStr(), CDbl(), etc... You probably have to do a compact/repair.

 

[Muriukis]

You change the structure of your database every month? That's a BAD
idea. Why not just use a query to convert from one type to the other
CStr(), CDbl(), etc... You probably have to do a compact/repair.

As pietlinden answered if you are ghanging data types every month some thing
is very wrong with your database normalization. Why do you have to change the
datatypes. If you can answer that then your problem is solved

 

[Dirk Goldgar]

In

I am trying to change the data type in one of my tables. I do it
every month and it works fine. This month I am getting an error
message that says it can't change the data type because "There isn't
enough disk space or memory". Any assistanve would appreciated.

As others have said, changing a data type every month is a very odd
thing to be doing, and that should probably be addressed as your primary
concern.

That said, the reason you can't do it this time may be related to the
size of the table. The action would be executed in a transaction which
preserves both the before and after version of each record, as well as
many record locks and other transaction control information. If the
table is very large, it may have grown to the point where the
transaction runs into a limit on the resources available to do that.