I have a database I am developing in MS-Access 2007. The size is not an issue, I have read the tip on slow response from a database with multiple forms. I am attaching several text files to the database in an "attachment" field type. After debugging the code I came to the realization that since I was crashing out of the application are these attachments being orphaned? If they are orphaned will the "Compact and Rebair Database" function get rid of the orphaned records. I would assume that when a record is deleted from the database, the appropriate "attachment" field information is also deleted. But since I am crashing out of the database, I am not properly closing the file. Does anyone have any thoughts on this?