Hi, I have a problem that the MS Access lock file (*.LDB) is left behind after some editing which is done though my update program. I need to get rid of this lock file so that I can rename the main database file, which I can not since it is basically in use and is locked. Does anyone have any experience in this field?, and any ideas of what I can do? I am using 100% DAO using OLEVariants to access the database. I run some append queries, and open some recordsets. I close the recordsets by using Table.Close, and then Table := UnAssigned, is their a better method... Chris --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz