Field size decrease

  • Thread starter Thread starter Deborah Mowry
  • Start date Start date
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
 
(snip)
Well, since Access does NOT store trailing blanks, it's not actually
going to save you much of anything.
Click to expand...

Well, that's true when you save the data via a form. It is the Access form
processing (not Jet) that strips the trailing blanks. But I'm not sure you
could count on that with other actions, like, importing data directly (not
via a form)?

TC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Field Lengths 2
Text Field Size - Access 2007 2
Reducing Database Size 4
Database Size Problem 5
Acoustics - 80Hz loss in car! 0
can't change the data type or field size 3
Splitting an Access Database into fe/be-b'cuz db too large 1.65 gi 10
Excel - Sliding decreasing scale (payroll tax calc) 2

Back
Top