Just a couple thoughts... I don't use ADO quite the way you do, in terms of how to write the ADO elements, but I'm wondering why not just convert the data up into SQL Server using the appropriate version of Microsoft's SSMA tool (SQL Server Migration Assistant). There's a different versions for quite a large number of combinations of SQL Server version and MS Access version. Then you can get away from corruption issues within the Access .MDB file.

Also, once you do something like that, all the Access tables become linked tables to the server that hosts the data, so then you don't need to play backup, and can instead rely on the SQL Server backup / restore capability.