So the following code worked beautifully in Access 2003. After upgrading to Office 2007, the code worked for about a week before I began getting the extremely helpful error message, "Unspecified Error". For some reason, whenever I got this error I could open the database in the old access 2003...