Ken Ismert
KIsmert at texassystems.com
Fri Sep 9 17:04:02 CDT 2005
Drop your relationships involving the field, reset the autonumber, then re-apply relationships. -Ken -----Original Message----- From: John W. Colby [mailto:jwcolby at colbyconsulting.com] Sent: Friday, September 09, 2005 3:04 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Reset Autonumber (WAS: Autonumber AssignedImmediately) Well I just tried it and get an error "Cannot change field YYY, it is part of one or more relationships." John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ken Ismert Sent: Friday, September 09, 2005 3:37 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Reset Autonumber (WAS: Autonumber AssignedImmediately) John, Yes, it works for tables with data. The only requirement is that the starting value must be 1 higher than the highest autonumber value already in the table, to aviod duplicate values. Also, if your autonumber field is set to random values, you are pretty much stuck with that. I wouldn't reset the autonumber value in that circumstance. -Ken