We have split an MS Access database so we have forms in a new frontend MS Access 2010 database and the data in a backend SQL Server 2008 R2 database. All works well apart from the html fields with email addresses and websites. Both fields are stored as nvarchar(max). The email fields are now shown as firstname.lastname@example.org#mailt
om# and websites as www.bsigroup.com#http://www.bsigroup.com#
The problem is we want to retain the Access Front End database forms but need the html fields to act as before so that users can select the field value and launch either a browser session or create a new email.
Thanks in advance