John W. Colby
jwcolby at colbyconsulting.com
Fri Sep 9 15:03:32 CDT 2005
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 -----Original Message----- From: John W. Colby [mailto:jwcolby at colbyconsulting.com] Sent: Friday, September 09, 2005 12:56 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Reset Autonumber (WAS: Autonumber Assigned Immediately) Ken, Does this method work for tables with data already in them, or only empty tables? John W. Colby www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com