Linking SQL and Access 2000 tables -- sql server odbc

Mary Chipman
5/19/2004 4:31:51 PM

SQL Server does not support hyperlinks in the same way that Access
does, so you are not going to get the same functionality. You can of
course store it in plain text in the table using the varchar or
nvarchar data types in the column definition.

--Mary

On Wed, 19 May 2004 07:58:21 -0700, "sean"
[quoted text, click to view]

Sean
5/21/2004 7:33:58 AM

Thanks Mary.
Is there any way at all, that you know of, that I can
embed the HTML link using SQL commands? My manager would
like to have the database set up in SQL DBM where all of
the computer inventory is given in columns, and then a
column with a link to each computer in the office's
Belarc program results is given, so that people viewing
the database may simply click on the link and see it...

Can I use XML language to create a link, or does SQL not
allow links at all? I'm sorry--neve rworked with SQL at
all, so i'm really new at this.

Thank you for your help though!!

Sean

Mary Chipman
5/24/2004 4:55:56 PM

You can save the link as plain text in a varchar column, but actually
following the link will have to be done by the client application.
Unlike Access, SQLS doesn't provide any client UI functionality --
it's just for storing data.

--Mary

On Fri, 21 May 2004 07:33:58 -0700, "Sean" <hockeyman133@hotmail.com>
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server odbc

sql server odbc : Linking SQL and Access 2000 tables