Just be sure to grab the correct version for SQL Server ... fine in your case. In any event, test your process thoroughly, including an actual database failover test, before you put anything ...

Using Access to build a front end for SQL ... to a SQL Server database? For starters, it's likely that your client's users will be more familiar with it, and it's relatively easy to put in place.