Sorry if this is a double post, but I don't see my previous post.
Anyway, I get the user name on an app via API. I'd like to check if the user has administrator privileges (besides checking if username = administrator) so that in case the db location changes, an administrator can change the location in the app, w/o recompiling and redistributing the app. This app will be installed locally on about 20 machines, but connect to a server.
Right now the server address is hardcoded, but if the address changes, I want the administrator to be able to reset it (even though this means doing so on twenty computers). I can't have an app on the server for 20 machines to connect to because it's an Access 97 db and I don't want data errors because Access can't handle that many connections. Thanks, and Merry Christmas/Happy Holidays to all.