My company (The Catholic Diocese) has an access DB that they use to track happenings at the various parishes. This DB is tied to another access DB to insure that information such as parish names, priest names . . . can not be changed as users update the parish information. The forms that are used to update the DB are contained with in the access DB itself.
A request has come down that the database should be web enabled and use an InfoPath forms front end so that the parishes can themselves submit the DB updates directly to the DB rather than returning their entry data to a central person who must then enter the data for all 130 parishes.
In my research I've read about web services and am interested in generating a web service so that the InfoPath form can talk to the Access DB and submit/retreive data according to the InfoPath forms.
What I need to know is Since the DB I want to update is tied to a second DB, how will the web service interact with both DBs at the same time? can it even do that? the other thing to consider is that the second DB is setup with username and password access.