If your Microsoft Access database is split into front end and back end, how can you easily modify, or programmatically change, the table structure on the back end? You could manually open the backend database and make the changes. But that is not convenient. What if you're off site? Do you ask the users to email the backend database to you? What if the split database resides on multiple laptop computers? The problem compounds. The solution? By using VBA code on the front end, you can remotely alter tables, fields, and indexes on the back end