You need to find out what they mean by "no longer wanting to support Access." And WHY. Because if they are still supporting Excel and network solutions, they are still supporting Access's base components that underlie ALL Office components. Your "VBA from Excel" solution would merely transfer the problem from one utility program to another, except that the new utility is less well-suited to the proposed operation than where you had it in the first place.
Frequently, "no longer support Access" stems from the narrow ignorance of an IT guy who dislikes Access because of what he has "heard." There is no official document that I have ever seen that says that "Access is bad for networks." The document says "Mismanaged security is bad for networks." And in that light, you can come here to ask questions about how to set up such things.
Before I retired, I worked with the U.S. Navy and it only took a brief session with our head IT security guy to get him to back down. The problem often isn't that they have bad experiences with Access - it is that they have NO experience with Access and therefore don't understand it.
Another issue is this: Does your boss like what the particular Access app does? Because if you tell the boss that he/she is about to lose a useful tool then you make this "someone else's problem" and are more likely to get someone else on your side of the argument. Trust me - having been in this exact situation many times before - clout counts.