Article View: comp.databases.ms-access
Article #552Re: Access/SQL Server
From: Tony Toews
Date: Sat, 13 Jan 2001 23:32
Date: Sat, 13 Jan 2001 23:32
20 lines
2040 bytes
2040 bytes
"TEST TESTPOP_Server=pop.freeuk.net" <testx@freeuk.com> wrote: >The Field which is updated is a number and is >part of the Primary Key. In my not so humble opinion <smile> this is poor database design. The primary key should be a number which has no meaning, ie like the AutoNumbers we use in Access. All child tables reference the parent table using this non meaningful number. I also realise that you likely don't have any control now over the design of the tables. Tony ---- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Technical Details
Message-ID:
<ol916tcimls1fmto8l8vofh2hhupgnteeh@4ax.com>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!t-online.de!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04References:
<DCJ76.170296$eT4.13196254@nnrp3.clara.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff0ac,e3db6de17c8debd X-Google-Attributes: gidff0ac,public X-Google-Thread: 1139e2,e3db6de17c8debd X-Google-Attributes: gid1139e2,public X-Google-Thread: f8db2,e3db6de17c8debd X-Google-Attributes: gidf8db2,public X-Google-Thread: 115bcb,e3db6de17c8debd X-Google-Attributes: gid115bcb,public X-Google-Thread: 10f31b,e3db6de17c8debd X-Google-Attributes: gid10f31b,public X-Google-ArrivalTime: 2001-01-13 15:36:04 PST From: Tony Toews <ttoews@telusplanet.net> Subject: Re: Access/SQL Server Date: Sat, 13 Jan 2001 16:32:30 -0700 Message-ID: <ol916tcimls1fmto8l8vofh2hhupgnteeh@4ax.com> References: <DCJ76.170296$eT4.13196254@nnrp3.clara.net> X-Newsreader: Forte Agent 1.7/32.534 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Newsgroups: comp.databases.ms-access,free.database.access,it.comp.database.access,microsoft.public.access.odbcclientsvr,microsoft.public.sqlserver.clients NNTP-Posting-Host: edtntnt11-port-2.dial.telus.net 161.184.204.2 Lines: 1 Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!t-online.de!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04