There was a windows shell script (.vbs) on stackoverflow that decomposes and recomposes a mysql file into text files and back. From the get go it exports Forms, Modules, Macros and Reports. Here is a link to that here. It's the first chosen answer. Now for some reason the original author chose not to export Tables and Queries or Table Relationships simply because they are stored kind of differently by Access. In addition that script deletes each 'object' as it exports it, so one difficulty was that you can't delete a table until you delete it's relationship. A bit of a hassle. Also he didn't provide support between .adp and .mdb files. You have to do that manually.
All of that is possible however, so if you have linkedtables you can figure out how to export them into text form. Then export the Relationships. Delete the Relationships, and then delete the tables. (If you've written the ip in any modules or pass-through queries you'll have to do it to them too.) Have the script delete them everything you chose to export from the original file. There after you will essentially have your msaccess file in a bunch of text files. From there on it's just a simple case of doing a find/replace for each file (through code) And then recomposing the file from each changed element.
It's a bummer to program but it sure helps a ton moving from production to development environments without a sweat.
Seems somebody did something similar to what I did, but probably better than my version:
Hmmm, If it works for you then great but that program isn't working for me :( Plus it's in C# :(