At some point in time most programmers are faced with a task where they need to recursively search through filesystem folders and perform some sort of operation on matched files. For VBA programmers in Access, this “operation” often involves the compaction and repair of .mdb and .accdb files in order to free up disk space on the filesystem.
Programming with VBA in Access allows for database manipulation that may be awkward or even impossible with standard data access techniques. This may be accomplished by writing code directly in the Visual Basic Editor (VBE), which includes a window for writing code, debugging code, and code module organization. To find out how to access the VBE by adding the developer toolbar to your excel 2007, 2010 and 2013 versions of Access, please follow the appropriate link in the Related Articles section.
Read More