Modify multiple MDB file's modules

[rkulek]

Hello,

I am not sure if it is possible, but I would like to modify multiple MDB file's modules instead of opening each one in Access and changing the line of code for each and every MDB file.
Is it possible to write code to open all (or open consecutively) MDB files that exist in a folder, modify the code in an existing module (find and replace), and then save the MDB?

 

[SydneyGeek]

It is possible to edit modules using VBA. The best tutorial I know is Excel - based: Programming In The VBA Editor
However, you will most likely need to go into each database first and change the security settings so that access the VBE is trusted. Otherwise Access will block attempts to modify code programatically.

Denis