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