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?
Competent Performer
Windows XP 
Access 2007
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?
Master of Nothing
Windows XP Access 2000
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
VIP
Windows 7 64bit Access 2007
And never be used for any purpose other than uniquely identifying a given Record! Period!Originally Posted by ssanfu
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Sometimes Helpful
Windows XP Access 2003
You guys are harsh. Remind never to show you my AutoNumbers!
VIP
Windows 7 64bit Access 2010 32bit
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.
Competent Performer
Windows XP Access 2007
Thanks, guys...i am clear now.
Master of Nothing
Windows XP Access 2000
Yeah, what June said..(my confuser doesn't know how to type)
Parsing Middle of String
Need to Remove Varying Middle Text
Posting Permissions
Reply With Quote