I have a table where the details are imported from excel and there is a autonumber as pk i have kept, but when ever i reset the autonumber and import the file the number starts from 30 i need it from 1 hw can i do it?
I have a table where the details are imported from excel and there is a autonumber as pk i have kept, but when ever i reset the autonumber and import the file the number starts from 30 i need it from 1 hw can i do it?
The only way to have an autonumber to start from one after records have been entered is to delete all records, then do a compile and repair.
Why do you need the autonumber field to start from 1?
The autonumber field should NEVER be visible to the users.
Autonumbers--What they are NOT and What They Are
http://www.utteraccess.com/wiki/index.php/Autonumbers
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
You guys are harsh. Remind never to show you my AutoNumbers!
Steve meant 'Compact and Repair'.
If you want every import to start with 1 then the ID is not unique. Autonumber is supposed to generate a unique ID for each record.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks, guys...i am clear now.
Yeah, what June said.. (my confuser doesn't know how to type)