I have a table within an Access DB that I am trying to update based on a copy of the same database. When I try to copy a record, I get a status bar across the bottom saying "Copying" and the first bar of blue lights up, but then it freezes. Access continues to run otherwise normal. When I close access I get an error that access can not delete the file after compacting it. I only get this error after I try to copy from a specific table that is giving me problems. I do have the db set to compact and repair on close, but I was having this problem long before enforcing that setting. Also, I can export the table to excel and then past the records in without problems. Likewise, the rest of the tables in the DB run just fine and let me copy and paste. There are not any security constraints on the DB or table. I am running windows 2000/Office 2000. Any help would be awesome!