A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

A2007 Hyperlink



 
 
Thread Tools Display Modes
  #1  
Old November 12th, 2008, 03:38 PM posted to microsoft.public.access.tablesdbdesign
JimS
external usenet poster
 
Posts: 252
Default A2007 Hyperlink

A2007 allows multiple hyperlinks in a single column. I want to update a
hyperlink column with some additional hyperlinks. The column may or may not
be null. It may have a hyperlink in it I want to add to .

What's the process? I know how to do an update query, I just don't know how
to structure the column. Do I just use the ampersand operator and update the
column that way, or do I need to place a separator between hyperlinks?
--
Jim
  #2  
Old November 14th, 2008, 07:44 PM posted to microsoft.public.access.tablesdbdesign
Chris O'C via AccessMonster.com
external usenet poster
 
Posts: 1,160
Default A2007 Hyperlink

You don't want to put multiple values in a single column in a relational
database. If you did, do you realize how much extra work it is to find the
desired part of the data with queries? To update the right part of the data?
To delete the right part of the data?

Store one value in each column in each record.

Chris
Microsoft MVP


JimS wrote:
A2007 allows multiple hyperlinks in a single column. I want to update a
hyperlink column with some additional hyperlinks. The column may or may not
be null. It may have a hyperlink in it I want to add to .

What's the process? I know how to do an update query, I just don't know how
to structure the column. Do I just use the ampersand operator and update the
column that way, or do I need to place a separator between hyperlinks?


--
Message posted via http://www.accessmonster.com

  #3  
Old November 14th, 2008, 08:15 PM posted to microsoft.public.access.tablesdbdesign
JimS
external usenet poster
 
Posts: 252
Default A2007 Hyperlink

While I generally agree with you that I wouldn't normally use a multivariate
capability, I think this is a reasonable exception. I see no time when I'd
want to search the column, and I do see that multiples make sense. MS has
made it quite easy to do, at least manually.

I could make it a "child" table, but I'm not sure it's worth the trouble.
--
Jim


"Chris O'C via AccessMonster.com" wrote:

You don't want to put multiple values in a single column in a relational
database. If you did, do you realize how much extra work it is to find the
desired part of the data with queries? To update the right part of the data?
To delete the right part of the data?

Store one value in each column in each record.

Chris
Microsoft MVP


JimS wrote:
A2007 allows multiple hyperlinks in a single column. I want to update a
hyperlink column with some additional hyperlinks. The column may or may not
be null. It may have a hyperlink in it I want to add to .

What's the process? I know how to do an update query, I just don't know how
to structure the column. Do I just use the ampersand operator and update the
column that way, or do I need to place a separator between hyperlinks?


--
Message posted via http://www.accessmonster.com


  #4  
Old November 14th, 2008, 09:02 PM posted to microsoft.public.access.tablesdbdesign
Chris O'C via AccessMonster.com
external usenet poster
 
Posts: 1,160
Default A2007 Hyperlink

If I had a nickel for every time a db needed to be fixed after the orginal
designer said "We'll never need to query that data so it doesn't matter how
we store it", I'd be able to retire.

It costs way, way more to fix the problem later when you've got 100,000
records with multiple values in a column that need to be separated than it
would have cost to build the db right in the first place.

It doesn't make sense to throw money away, even when Microsoft makes it easy.
Don't put multiple values in any column. Store one value per column per
record.

Chris
Microsoft MVP


JimS wrote:
While I generally agree with you that I wouldn't normally use a multivariate
capability, I think this is a reasonable exception. I see no time when I'd
want to search the column, and I do see that multiples make sense. MS has
made it quite easy to do, at least manually.

I could make it a "child" table, but I'm not sure it's worth the trouble.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200811/1

  #5  
Old November 14th, 2008, 09:11 PM posted to microsoft.public.access.tablesdbdesign
JimS
external usenet poster
 
Posts: 252
Default A2007 Hyperlink

I've reconsidered. It wasn't as easy as I thought, and it's not that hard to
have a secondary table. The secondary table could even save disk space. Thanks
--
Jim


"Chris O'C via AccessMonster.com" wrote:

If I had a nickel for every time a db needed to be fixed after the orginal
designer said "We'll never need to query that data so it doesn't matter how
we store it", I'd be able to retire.

It costs way, way more to fix the problem later when you've got 100,000
records with multiple values in a column that need to be separated than it
would have cost to build the db right in the first place.

It doesn't make sense to throw money away, even when Microsoft makes it easy.
Don't put multiple values in any column. Store one value per column per
record.

Chris
Microsoft MVP


JimS wrote:
While I generally agree with you that I wouldn't normally use a multivariate
capability, I think this is a reasonable exception. I see no time when I'd
want to search the column, and I do see that multiples make sense. MS has
made it quite easy to do, at least manually.

I could make it a "child" table, but I'm not sure it's worth the trouble.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200811/1


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.