I've built a database (Production) with user level security on it. I also have built a smaller database (Login) so I don't have to use Access' login. I'm trying to figure out if there is a way to change the user password in the Production database FROM the Login database. I've been working with the following code and trying to make it work on another database other than the CurrentDb(DBEngine(0)):
I hope I explained that well. Let me know what you think.
Software/Hardware used: MS Access, Windows XP, VBA
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!