Yes, it will work on 2010 and above. Access may not be reverse-compatible in the sense of opening a 2010 database in 2007 or 2003, but you can find examples of code online from 2003 and earlier that work perfectly in later editions. I've never known MS to remove a functionality from later versions once it has been developed and installed.
This does sound like a good solution. Good luck.