Hyperlinks work in access, but once it is converted to SQL backend hyperlinks
is not an option. There is no equivalent, does any one have a solution to
this, I really need to attach excel, word, PDF, emails to the database that
go along with the case files. Any help provided would be greatly
appreciated.

Thanks,
PB

Store the paths, and use the following code which works with the
ShellExecute api to open the files. Not only will it fix your problem, but
it will lower storage overhead and possible corruption:

http://www.mvps.org/access/api/api0018.htm

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"PB" <PB@discussions.microsoft.com> wrote in message
news:2053DB68-B8DE-4612-9D02-0D7B5FB18E5F@microsoft.com...
> Hyperlinks work in access, but once it is converted to SQL backend
> hyperlinks
> is not an option. There is no equivalent, does any one have a solution to
> this, I really need to attach excel, word, PDF, emails to the database
> that
> go along with the case files. Any help provided would be greatly
> appreciated.
>
> Thanks,
> PB
>

Arvin,

Thanks for the info; I just have a few more questions do I write this code
behind the text box in say after update? Not sure where to put it. Also the
form I am using is continuous is that a problem? Thanks again for your help
it is appreciated.

Pb

"Arvin Meyer [MVP]" wrote:

> Store the paths, and use the following code which works with the
> ShellExecute api to open the files. Not only will it fix your problem, but
> it will lower storage overhead and possible corruption:
>
> http://www.mvps.org/access/api/api0018.htm
>
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
>
> "PB" <PB@discussions.microsoft.com> wrote in message
> news:2053DB68-B8DE-4612-9D02-0D7B5FB18E5F@microsoft.com...
> > Hyperlinks work in access, but once it is converted to SQL backend
> > hyperlinks
> > is not an option. There is no equivalent, does any one have a solution to
> > this, I really need to attach excel, word, PDF, emails to the database
> > that
> > go along with the case files. Any help provided would be greatly
> > appreciated.
> >
> > Thanks,
> > PB
> >
>
>
>