Changing a Field Size

[Guest]

I am trying to change the Field Size of a field and when I attempt to save, I
get an error that says "There isn't enough disk or memory." Any suggestions
to help me out? If it helps, when compacted, the database is about 125 Mb.

Thanks

 

[Joseph Meehan]

I am trying to change the Field Size of a field and when I attempt to
save, I get an error that says "There isn't enough disk or memory."
Any suggestions to help me out? If it helps, when compacted, the
database is about 125 Mb.

Thanks

I seem to remember a specific problem with that. What version Access
are you using?

How much disk space if free on the drive? How much memory is available
on the computer?

 

[Guest]

Access 2003. The database is stored on the company directory so no problems
with disk space. The memory I'm unsure of but I don't have a problem running
anything else.

 

[John W. Vinson]

I am trying to change the Field Size of a field and when I attempt to save, I
get an error that says "There isn't enough disk or memory." Any suggestions
to help me out? If it helps, when compacted, the database is about 125 Mb.

Thanks

I'd suggest creating a new, empty table (copy and paste the existing one,
design mode only); change the field size in this new table; and run an Append
query to migrate the data. Drop any relationships to the old table,
reestablish them to the new table, and delete the old table - and compact and
repair again.

Back up the database first of course!!

John W. Vinson [MVP]

 

[John W. Vinson]

Access 2003. The database is stored on the company directory so no problems
with disk space. The memory I'm unsure of but I don't have a problem running
anything else.

I think the problem is that when you attempt to change the design of a field
in an existing table, Access tries to load the entire table into memory TWICE
- the old table and the new one - before writing it out. Hence my suggestion
to use an append query instead; that will do it one record at a time rather
than the whole table.

John W. Vinson [MVP]