Hyperlink in MS Access Database

[Neilelph]

Hi.

I have a table within an MS Access database which has a column of type hyperlink. I am populating this column using the built in database tools in TestStand. I am passing in a path to a file which is of TestStand type String.

The database gets populated correctly with the required text, and looks like a proper hyperlink. Unfortunately, when the link is clicked in Access nothing happens - the link has no address associated with it (if that makes sense).

I have attached a sample sequence which shows the problem.

Has anyone come across this problem before, and if so, can it be overcome?

Cheers.
N.

[Scott_Richardson]

Neilelph
I have never used them before, but if I create a simple table with a hyperlink field and query the value as a string, the value that is returned is surrounded by # characters, i.e. "#d:\temp\temp.seq#". Try pushing the value into the database from TestStand using the extra surrounding # characters.

[Neilelph]

That works a treat. Cheers.