Hyperlinks get corrupted on Save

[raviyah]

I have a system I am developing in Access which creates an Excel spreadsheet.
There are hyperlinks in the spreadsheet.

I am working on one server which I using for development and the system
works fine.

On the server where the production version is running, when the excel
spreadsheet is saved, the hyperlinks change from '\' to '/' and from ' ' to
'%20'.

This only happens on the production server. If I copy the spreadsheet from
the development server to the production server, it works fine until I save
it. Then it doesn't work.

When I put a debug break in the program and look at the worksheet, the
hyperlinks work fine. When I save the spreadsheet at the end, the hyperlinks
fail.

any ideas?

 

[Allen Browne]

Instead of the hyperlink field, use a Text type (or Memo if they may be >255
char.)

You can still build a hyperlink string to execute, e.g.:
Dim strLink as String
If Not IsNull(Me.[SomeField]) Then
strLink = "file:///" & strLink & "#" & strLink & "#"
FollowHyperlink strLink
End If