Timeline for How do I set the first value of AutoNumber in Access?
Current License: CC BY-SA 3.0
15 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jun 27, 2018 at 14:18 | answer | added | muhammad | timeline score: 3 | |
Feb 10, 2018 at 22:13 | answer | added | George | timeline score: 1 | |
Nov 12, 2017 at 15:50 | answer | added | ssurjie | timeline score: 0 | |
Mar 20, 2017 at 10:17 | history | edited | CommunityBot |
replaced http://superuser.com/ with https://superuser.com/
|
|
Feb 24, 2017 at 2:19 | answer | added | Brent | timeline score: 0 | |
Jan 24, 2017 at 18:13 | answer | added | RunsWithScissors | timeline score: 0 | |
Nov 28, 2014 at 11:34 | history | edited | Oliver Salzburg |
edited tags
|
|
May 13, 2013 at 11:35 | review | Suggested edits | |||
May 13, 2013 at 11:40 | |||||
May 24, 2011 at 20:59 | comment | added | Pylsa | Rest of @BaconBits's comment: nce you see articles like this when something goes pear-shaped because people expect Autonumber to be something it's not. If you need to generate numbers in this manner, write the queries and such in the DB to do it properly yourself. | |
May 24, 2011 at 20:59 | comment | added | James Mertz | @BaconBits... what then is AutoNumber meant to be used for? | |
May 24, 2011 at 20:58 | vote | accept | James Mertz | ||
May 24, 2011 at 20:42 | comment | added | Bacon Bits | Not an answer, but a warning: Autonumber is not designed to be managed in this way. I've seen countless people try it. It never works because the DB will do weird things incrementing sometimes (failed writes still increment the number, for example). Autonumber does not guarantee that the record numbers will be consecutive. Indeed, in rare cases it won't even guarantee the number will be unique. It's very useful for creating a primary key for a small table. It's a little risky for large tables. It's absolutely awful for using as an actual data field. He | |
May 24, 2011 at 20:33 | answer | added | Pylsa | timeline score: 19 | |
May 24, 2011 at 20:18 | answer | added | music2myear | timeline score: 0 | |
May 24, 2011 at 20:07 | history | asked | James Mertz | CC BY-SA 3.0 |