Migrating Microsoft Access to Microsoft .NET

The clients used in the locations access web services via HTTPS. The web services are installed on an IIS. The IIS is located in a fast LAN to which the database server is also linked. When a web service is called, the user's authorization to run the web service is checked on the IIS. The user's identify is also used when accessing the database; the server must be prepared for the double hop. When data is changed, only changed or new records are transferred. The reply to these calls updates the correct data to the client. Errors that occur in the servers are logged centrally using a web service. The transaction across multiple change-accesses to the database is processed by means of MS Distributed Transaction Services (MSDTC). Evaluations are realized using MS SQL server reporting services.