When I was last working on my database for cable and equipment tracking, I simply tired to add some break point in my code to troubleshoot an issue and the database crashed. The file closed and I got an error message that Access couldn't compact the database and there was a new file with the name Database.mdb and my original database was locked and only 1 kb in size. Luckily I had a back up so I just lost my work from yesterday which wasn't a whole lot. However it got me thinking about my database and finally admit to myself that some of the buttons and things that I have created are extremely unnecessary. Mostly, the command buttons that I programed for Saving, navigation through records and having very similar search functions on different forms. Also possible more queries than I need.
Granted, I am not sure if any of that is related to why the database crashed so bad, but I figure it can't make anything worse by removing the extra coding that is not needed. I know that access can be kind of weird in the way that things are deleted and I am just wondering if there is a best practice for deleting code. If I delete a command button from a form will that also delete the code or should I delete the code and then delete the command button? Or does it matter?