Yep. I think I'll do this again. I did it yesterday but I don't think something worked correctly.
STRANGE.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jpjones23@centurylink.net
Sent: Wednesday, February 12, 2014 10:14 AM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] RE: autonum with missing values
Liz,
The first thing I'd do is to backup the database, just in case.
Jeff
From: "John Viescas" <JohnV@msn.com>
To: "MS Access Professionals" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, February 12, 2014 12:10:31 PM
Subject: 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
(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 |
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.
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.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (8) |
Tidak ada komentar:
Posting Komentar