I have a database, that is really bloated, and I am trying to reduce the file size by changing five number fields from Decimal to Long Integer. However, it keeps telling me that it doesn't have the memory to perform this task. When I compact and repair it, it clears all the indexes I had in that table, including my primary key. I've got close to a million records in that table, because it houses service calls for the past year. Do you have any suggestions as to how I can correct this problem and keep it from happening in the future?