Re: Natural keys vs Aritficial Keys

paul c <toledobythesea_at_oohay.ac> wrote:

>>> And no synthetic key will solve the problem that someone was stupid
>>> enough to fill a warehouse with no internal subdivision and no way to
>>> identify where in the warehouse inventory was put. (In the example
>>> cited, the warehouse being a huge gravel field.)
>>
>> No, not having internal subdivisions was not the problem. People errors were the
>> problem. Which happens in every project large or small. Trouble is these are among
>> the larger projects. One job site at which I worked had 15,000 construction people
>> on site building the plant.
>>
>> Tony
>
>Just two questions for no particular reason: 1) was that on the coast?

No, this was in Alberta, Canada.

>2) did you use Access?

Yes. That particular app mentioned in the last sentence was tracking the progress of 300 electricians per 12 hour shift so well within Access's capabilities. Once the job was done the app and data was archived and likely never used again.

Tony

-- 
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/