[AccessD] autonumber

I'll have to look through the archives myself on this one.  (I'll have them
running this weekend...for me! <grin>  SBC says my DSL will be up next
Thursday (barely a week, yippie!)).  (Actually, in case anyone forgot,
http://intranet.marlow.com/AccessD still works...it just doesn't have
anything after this past January/December (and it's not  as fast as what I
had online for a whopping 36 hours...<grin>))

I always thought that the only real cardinal sin with AN's, was to use them
as a true incremental value.  (ie, expecting that if there is a 2 and a 4,
that there is also a 3).

I personally don't see any harm is using the AN for purposes other then a
key, nor do I see any harm with showing the user an AN, though a lot of
times, a user just wants a number, so it doesn't matter if it's an AN, or
something else.

I know I probably just opened a HUGE can of worms, but heck, I had
intermittent List time (been busy with other things), however since 11 pm on
the 15th (it's now 4 am on the 17th), there has only been 70 posts.....come
on folks...that's pathetic?  JC, what can we argue about?  We need more
posts!  <evilgrin>

Drew

-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us]
Sent: Wednesday, April 16, 2003 7:46 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] autonumber


John,

I cannot let this pass without asking why do you care?  You are not
committing the cardinal sin of allowing you users to see the autonumber
field are you?  <grin>  If so, check the archives on why this is a
cardinal sin.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Drew Wutka [mailto:DWUTKA at marlow.com] 
Sent: Wednesday 2003 Apr 16 05:02
To: 'AccessD at databaseadvisors.com '
Subject: RE: [AccessD] autonumber

A make table query should already 'reset' the AutoNumber, since it is
going to make a new table. An append query can be used to 'set' numbers
within an AutoNumber field, however, it doesn't reset the counter, it
can just 'ignore' it.  If you delete the data in a table, to resent the
AutoNumber counter, compact the database.  It will reset the counter (on
an incremental
AN) to the highest number plus 1 (or 1, if there are no records
remaining).

Drew

-----Original Message-----
From: John Eget
To: AccessD at databaseadvisors.com
Sent: 4/16/03 4:43 AM
Subject: [AccessD] autonumber

Is there a way to reset the autonumber to 1 of a make table query or an
append or a table I just finished deleting the information from? John
<<ATT46269.txt>> 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com