I am trying to design a utility for users to change passwords on multiple systems from one window. Since much work is done in Access databases, we have about 20 MDW Workgroup files across our network for each of 20 different Access databases.
Is there a way to change a password in the Workgroup file without opening Access? Or maybe there is a way using VBScript to connect to an Access database using GetObject(Application.MSAccess) or something like that.
Any help or comments are GREATLY appreciated.