Hi, all
Recently our server name changed, all links for tables are broken, there hundreds of database in hundreds folders.
How can I update all links for all link tables in all databases in all subfolders?
I know how to use VBA, but I only worked on one database (with link tables to other database), I never open another database in VBA code and change anythings, I don't know how to scan subfolders for all .mdb files either.
Would somebody give me a flow chart(of course the more details the better) with key function names to accomplish this?
Any help is very appreciated.