Microsoft Access Remote Use | Access Remote User

Access & SQL Server

Allowing Access to work with small numbers of remote users

If you have less than 10 people that work with your Access database and they are employees or contractors to your organization, there are some simple and cost-effective methods WSI can employee to make this happen to allow them to interact with your database from where they are located.. Basically, it involves splitting your database to a separate FE (front end – screen forms, reports and queries) and BE. Upsizing the BE to Microsoft SQL Server. Then putting the Microsoft SQL Server BE onto a host of your choice, one of the servers WSI manages or Microsoft Azure SQL service. Last, we need to modify each users FE to connect to the host Microsoft SQL Server instead of a local database.

Contact us today to get started on working with WSI!