My application will be given an employee number. It has to query a database for the username and group memberships matching this employee. I have to use Access or MS SQL. I cannot use ADSI. Multiple applications will eventually query similar info from the same database. There will be an initial load of 5000 - 10000 queries per day. (looking at the current logged in user is cheating)
1) I can put the database inquiry direct in the application
2) I can design a web service to return the same information, and put the database inquiry there.
My thought is the fact that other applications will probably access the same info, better to use the service. Plus it seems cool.
Thoughts on the subject?