I just searched and found another post that covers my issue. I have several large database tables that have suddenly rounded all dollar amount to 0 decimals, even though the settings for the fields have not been changed from double, 2 decimals. The file is in Access 2000 Format, and I have checked in both Access 2002 and 2003 and the decimals are gone. The tables involved are over 300,000 rows of data and are for 1 year periods with daily downloads, so redoing is a daunting option. I may be able to restore the tables, but what precautions should I take to prevent this from happening again? Is there a glitch?