Recent content by Dennis

Compact and repair did make the file size less. I am not as familiar with the access format, but dbf's were fixed length records so modifying the text width made a difference in file size.

All my text fields are set to 255 character width. I want to make the table / database a smaller file, I want to change the 255 character widths to 30-100 characters to shrink the file.

I have a 1.5 Million record database. When it was originally designed field widths were set to 255 bytes wide. My database size is almost 2GB and I would like to a shorter length. When I use the design window it errors out due to lack of memory. When I copy the structure to a new table...