Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 23rd, 2004, 09:49 AM
Registered User
Join Date: Aug 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Autonumber on Access 2002

I have converted an Access 2 database to Access 2002. Some tables have an Autonumber index. The number generated by new records is not the highest number + 1, but is a blank number in middle. If an attempt is made to save another record immediately afterwards and the next number up is used, it will display error message that not able to save because will create duplicate value. How can I make the autonumber add to the highest number in the table. Thanks.

Old August 23rd, 2004, 10:33 AM
Authorized User
Join Date: Jul 2004
Posts: 66
Thanks: 0
Thanked 0 Times in 0 Posts

I had this problem once, I had to drop the field from the table, then add it setting it autonumber, increment,dups not ok.

Similar Threads
Thread Thread Starter Forum Replies Last Post
AutoNumber in MS Access iii_carlos BOOK: Beginning VB.NET Databases 6 January 31st, 2007 08:23 PM
Autonumber in Microsoft Access ozzii Classic ASP Databases 1 January 17th, 2007 04:08 PM
Access Autonumber chall90909 Access ASP 1 November 21st, 2004 10:26 AM
ASP and Access AutoNumber phungleon Access ASP 2 October 10th, 2003 03:59 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.