Is it possible to retrieve vba from another DB?

[Edgar]

If I use the batch method it shouldn't be hard. It's a small enough company I can call 2-3 people and get everyone to close it out for 5 minutes.

I have not read the entire thread. But by looking at this:

it prompts for update and will run a query to copy and replace all the forms and modules.

I hope that it all works well in the end for you but, in my experience, if one thing goes wrong, corruption will happen, access is a very sensitive application and it will complain in the worst way possible. Instead, there should be an orchestrator outside to do at least this operation:
1. Renames old front end file as backup
2. Copies new front end file


3. Moves backup to backed up files folder
4. Exits
This way you can revert changes should that be necessary. Otherwise, well, you replaced things that were working before, now you'll have to figure out what went wrong.

Edit:
Replaced is not the right word, Destroyed is a much more appropriate word.

[Micron]

write a batch file that cycles through the folder and stores the name of the file before copying the master and renaming it to the stored value.

Unless things have changed, you can't overwrite Access files in use, so you end up with different versions in use at the same time. Don't overthink it - either just download and open every time, or open db, check version in fe table (or custom db property but table is simpler) and shut down if they don't match, then let them do whatever to replace their fe. The only thing you need to do is make sure the newly deployed fe has the new custom property value or the table has the proper value.

EDIT - Just saw prior post. Yes you can call everyone - pita and useless if they're at a meeting or out of the office for a bit.

[Welshgasman]

I am sure your time could be better utilised making something you need, not reinventing the wheel?