Issues I've encountered:

1) Access' hyperlink datatype is not supported in SQL Server. (It is converted to text.) Access systems that use hyperlink fields will lose that functionality. There are workarounds...