ACCESS FEED: Re: [MS_AccessPros] RE: autonum with missing values

Rabu, 12 Februari 2014

Re: [MS_AccessPros] RE: autonum with missing values

Liz-

Something has gone wrong in your table. Consider copying the table to the clipboard, paste structure only to a new table, then paste append. Your new table should have its next Autonumber set correctly, so just delete the old table and rename the new. (You'll have to delete and rebuild any relationships.)

An alternative is to run a command like this:

ALTER TABLE MyTable ALTER COLUMN AutoNumber COUNTER (x, 1)

… where MyTable is the name of your table, AutoNumber is the name of your field, and X is the highest current value plus 1.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Feb 12, 2014, at 5:56 PM, Liz Ravenwood <liz_ravenwood@beaerospace.com> wrote:

I don't think it is behaving well. I got a bad feeling about this.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Wednesday, February 12, 2014 9:40 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: autonum with missing values

Thanks Darrell. It is set to Increment.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Embrey, Darrell
Sent: Wednesday, February 12, 2014 9:25 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] RE: autonum with missing values

Hi Liz,
Check the Increment property for the Autonumber field in design mode. Is it set to Increment or Random?

Darrell

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Wednesday, February 12, 2014 11:10 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: autonum with missing values

Also, when they just click new, it picks an unused number that isn't the last and highest. This seems reasonable to me considering all the data I had to delete.

I need to maintain the existing autonumber generated value, so I don't want to resquence them.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Wednesday, February 12, 2014 9:04 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] autonum with missing values

Pros, I messed up a database and had to delete a bunch of data. I have an autonumber field and a procedure that allows someone to duplicate a record.

When they duplicate a record it isn't taking the highest of the high, but a number in the middle. Is this normal behavior?

Arrgh…

Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments

1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

The information contained in this communication is highly confidential and is intended solely for the use of the individual(s) to whom this communication is directed. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information is prohibited. Please notify the sender, by electronic mail or telephone, of any unintended receipt and delete the original message without making any copies.
Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan are nonprofit corporations and independent licensees of the Blue Cross and Blue Shield Association.

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.