Catch 22.

[Fuga]

Ok, so I decided to change the datatype for a few fields in a large table (from dbl to sng), in order to decrease the size of the db. Access replied it was unable to change the type due to insufficient memory.

So I need more free memory, but in order to get it I need more memory.

Does anyone have a good idea on how to go about this?

and another thing:

I got the briliant idea of making a structure copy of the table, changing the datatype, and then appending the rows with a query. The thing was all of a sudden the db started showing stupid numbers such as 9.00000000003 or 23.9999999999, so I had to replace the table from a backup.

What kind of problem is this actually? I think I´ve had it before.

Fuga.

 

[3699wat]

The warning of not having enough memory more than likely does not relate to the "physical" memory of your system. This happened to me at times after working on / changing forms/reports/codes in one database over and over. The only solution is to open a new database and copy everything (tables with structure only).
About changing the datattype. You will have to set the properties (e.g. decimal places) to your specs. Access will not do that for you automatically.