Hyperlinks with Access/SQL7 Flakiness

[Kubilus1]

Hello experts,
We have an Access97 database with linked data from SQL7. This is an 'Upsized' database from Access 97.

One form recieved data from a table containing hyperlinks. Hyperlinks are not a allowed in SQL so I did the following as a work around:

* I converted the entire table to SQL with all old hyperlinks being changed to text fields.
* I linked the table to Access, and in Access made a make table query containing only an index column and the hyperlink column from the original table. I converted the new tables column to be a hyperlink.
* Then I created a query in Access joining the SQL table and the Hyperlink table.

This seemed to work fine for awhile. Users could add hyperlinks, Entries without hyperlinks still show up in the query. However I have started to notice some very odd and flaky occurances between the form and new entries to the table.

I need to know if my method for perserving hyperlinks is flawed, and if there is another better way to take care of this problem.

Thanks a ton,
Matt

 

[Kubilus1]

To answer my own question, I found a better way to deal with linked tables with hyperlink fields from sql.
Instead of creating a query from the access table containing the hyperlinks, and the sql table with the other data, I simply created a subform containing only the hyperlinks field and linked that to the main form. All the strange problems I was experiencing went away.

Linking the data on the form than in a query seems to be a cleaner way to accomplish this, and in retrospect I should have done this in the first place.

Matt