D
Deborah Mowry
I have downloaded a table from a Lotus Notes system. The table is fine in
most regards except that all fields are text of field size 255.
I wanted to decrease these to a realistic number (e.g. 25) as I thought this
would somehow reduce the file size of the database which as a table alone
has currently 70,000 plus records.
Problem: get an error when I change any of them "MS Access cannot change the
data type. There isn't enough disk space or memory"
Any ideas as to why I cannot reduce the field size?
Deborah
most regards except that all fields are text of field size 255.
I wanted to decrease these to a realistic number (e.g. 25) as I thought this
would somehow reduce the file size of the database which as a table alone
has currently 70,000 plus records.
Problem: get an error when I change any of them "MS Access cannot change the
data type. There isn't enough disk space or memory"
Any ideas as to why I cannot reduce the field size?
Deborah