Access & SQL tables hyperlink (fields) to Word

[bradmaunsell]

I have a problem with Access quoting application that creates Word documents.

An insurance underwriter makes a few selections on a rating screen and then clicks a button to generate a Word document. Word opens, selects a template, interrogates the database, populates some bookmarks, creates a couple of Word tables, and finally names and saves the document. After saving the document, the software writes a hyperlink to a table. This all works fine in Access 97, 2000 and 2003

However, after converting to SQL, the hyperlink function no longer works. As you may know, Access has a field type "Hyperlink". Neither SQL 7 or SQL 2000 have a hyperlink type field.

Anybody have and thoughs regarding how to handle this new problem? If I cannot use SQL, I think I can co-mingle Access and SQL tables to get the job done.

Thanks,
Brad

 

[bradmaunsell]

Perhaps this I should have put this question in a different forum.

I figured it out and it is actually quite simple - just use the hyperlink follow command.

Brad
South Burlington, VT