I think that you will find that what you are asking for is a mix of back-end storage and front-end (client) formatting. Access really blurs the line between these two (very different) functions. SQL Server, on the other hand, is clearly a back-end storage system (ie, minimal client-side formatting features).
What you will end up having to do is to store text values for URLs and/or file locations and then use a client-side script/program/tool to format the data for presentation.
I personally like to pull the data using an ADO stream formatted in XML and then transform it with an XSL template. It's fast (as long as the recordsets aren't too big), it's flexible and gives you a great deal of control over how the data is represented.
This is not, however, the only solution.
Originally Posted by graceson
Have you hugged your backup today?