Re: setting hyperlink value in DAO 3.51 using an update query

From: lance (here_at_there.com)
Date: 05/14/04 

Date: Fri, 14 May 2004 13:50:39 -0500

according to the access 2000 help file, it does convert it to an access 97
file, and access 97 supports hyperlinks. so, armed with that information,
i'll repost my original dilemma here:

i'm trying to set the hyperlink value in an access database using DA0 3.51
on a field who's data type is set to hyperlink (table was created in
access2000, and converted to a previous version via the tools menu. my
program interacts with the converted database). using an update query like
such....

UPDATE Points SET Points.Hyperlink = "c:\id.jpg#c:\id.jpg" WHERE
Points.ID_In_Project = 1;

but the value after the "#" sign isn't being set as the link. am i missing
something?

lance

"lance" <here@there.com> wrote in message
news:uho44UcOEHA.2740@TK2MSFTNGP11.phx.gbl...
> when converted to a previous version via the tools menu, it doesn't give
an
> option. i'm assuming access 97, though, since the resulting database
works
> with an application that won't accept anything but access97.
>
> in any case, when i open the converted database, the hyperlink field is
> actually underlined and displayed like a hyperlink, as well as shows the
> hyperlink menu when right-clicked. it just has an empty "link" value.
>
>
> "Jeff Johnson [MVP: VB]" <i.get@enough.spam> wrote in message
> news:%23039DOcOEHA.1616@TK2MSFTNGP12.phx.gbl...
> >
> > "lance" <here@there.com> wrote in message
> > news:ute0cEcOEHA.556@tk2msftngp13.phx.gbl...
> >
> > > i'm trying to set the hyperlink value in an access database using DA0
> 3.51
> > > on a field who's data type is set to hyperlink (table was created in
> > > access2000, and converted to a previous version via the tools menu.
my
> > > program interacts with the converted database). using an update query
> > like
> > > such....
> > >
> > > UPDATE Points SET Points.Hyperlink = "c:\id.jpg#c:\id.jpg" WHERE
> > > Points.ID_In_Project = 1;
> > >
> > > but the value after the "#" sign isn't being set as the link. am i
> > missing
> > > something?
> >
> > What "previous version" was the database converted to and does that
> previous
> > version support the hyperlink data type?
> >
> >
>
>

Relevant Pages
Loading