dbTalk Databases Forums  

Re: AutoNumber Regeneration

comp.databases.ms-access comp.databases.ms-access


Discuss Re: AutoNumber Regeneration in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #21  
Old   
david epsom dot com dot au
 
Posts: n/a

Default Re: AutoNumber Regeneration - 12-16-2004 , 09:55 PM






Quote:
They also get re-used when someone dies.
Not deliberately. The location of the SSN FAQ has changed:
it is now here:

http://archive.cpsr.org/cpsr/privacy/ssn/ssn.faq.html

Most of the links in that document are broken. The discussion
of problems with the use of SSN's as primary keys is here:

http://archive.cpsr.org/cpsr/privacy...-addendum.html

(david)



"Trevor Best" <nospam (AT) besty (DOT) org.uk> wrote

Quote:
Rick Brandt wrote:
"Bas Cost Budde" <b.costbudde (AT) heuvelqop (DOT) nl> wrote in message
news:cposka$dhn$3 (AT) news2 (DOT) solcon.nl...

Tony Toews wrote:


how do you get a natural key for a person? SSN? No.

Hey! Why not? I am not familiar with SSN but there is a pendant
structure in Holland, the number should be unique. Is SSN not?


From what I hear "it's supposed to be" would be the answer to your
question. Fraud and screw-ups dictate otherwise.

They also get re-used when someone dies.

--
This sig left intentionally blank



Reply With Quote
  #22  
Old   
Larry Linson
 
Posts: n/a

Default Re: AutoNumber Regeneration - 12-17-2004 , 11:27 PM






"Tony D'Ambra" wrote

Quote:
Firstly, I find your use of "Eh?" offensive.
Your MVP status does not exempt
you from the rules of simple courtesy...
It's a Canadian speech habit thing that carries over into writing... not
intended to be offensive nor discourteous. Perhaps it has some different
meaning or usage in Oz?




Reply With Quote
  #23  
Old   
Larry Linson
 
Posts: n/a

Default Re: AutoNumber Regeneration - 12-17-2004 , 11:36 PM



"Steve Jorgensen" wrote

Quote:
Well, lots. The place I was working
where it was happening routinely had
over 100 users hitting the same
back-end.
Ah, that is near-record territory. Consider yourself added to the "people
whose observations we can trust" when we talk about the upper limits of
multiuser. Hey, it's good company, including michka, Stephen Forte, Drew
Wutka, and Mike Groh...

Like David, I don't have personal experience with that size user audience.
But that is quite a lot of users, and likely to stress a poor little
"desktop database" somewhat. But, as David also said, it'd be worth a check
that all users are up-to-date with SPs for Jet 4. Wouldn't it be nice if
that were a solvable problem, and you solved it for your client?

Larry Linson
Microsoft Access MVP




Reply With Quote
  #24  
Old   
rkc
 
Posts: n/a

Default Re: AutoNumber Regeneration - 12-18-2004 , 04:47 AM



Larry Linson wrote:
Quote:
"Tony D'Ambra" wrote

Firstly, I find your use of "Eh?" offensive.
Your MVP status does not exempt
you from the rules of simple courtesy...

It's a Canadian speech habit thing that carries over into writing... not
intended to be offensive nor discourteous. Perhaps it has some different
meaning or usage in Oz?
Interesting spin. In my experience "Eh?" is usually tacked on to
the end of a sentence by afore referenced Canadians.


Reply With Quote
  #25  
Old   
Larry Linson
 
Posts: n/a

Default Re: AutoNumber Regeneration - 12-18-2004 , 06:03 PM



"rkc" wrote

Quote:
Interesting spin. In my experience "Eh?" is usually tacked on to
the end of a sentence by afore referenced Canadians.
That, too. I took Tony's use to be more-or-less equivalent to my saying
something like: "Interesting. My own observation is...".

Larry Linson




Reply With Quote
  #26  
Old   
Trevor Best
 
Posts: n/a

Default Re: AutoNumber Regeneration - 12-18-2004 , 06:46 PM



Larry Linson wrote:
Quote:
"rkc" wrote


Interesting spin. In my experience "Eh?" is usually tacked on to
the end of a sentence by afore referenced Canadians.


That, too. I took Tony's use to be more-or-less equivalent to my saying
something like: "Interesting. My own observation is...".
Bejeezus, that's what I thought :-)

--
This sig left intentionally blank


Reply With Quote
Reply




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 On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.