Hey all..first post here, hope this is the right place. I have an elaborate Access 2K3 database that I'm working on. The data is a SQL Server (2000 for now, migrating to 2008 in about a week) that I'm running stored procedures on. In my one stored proc, I have a web link generated concantenating the beginning of the URL, and then the data from my database ('http://maps.google.ca/maps?ie=UTF-8&oe=UTF-8&hl=en&tab=wl&q='+UpperCoordinate+','+LeftCoordin ate). This has worked beautifully for me in the Excel version of this application, so I know the syntax is right. The problem is that when I export the Report to HTML and click on the link, my Windows Explorer opens to my desktop. When I look at where the address is pointing, it is in fact file:///C:\...\desktop. Argh. I read somewhere that there is a problem exporting HTML tags from Access -> HTML, but I am hoping that there's a way I can do this.



Any help would be appreciated.
TIA,
Chris