Hi,
This is really weird... I have a database that has an autonumber field.
Records 1-70 were deleted. Various things have changed to the front end and
a few extra fields added to the table.
Now Access has decided to re-use 1-70 again!!! however this went unnoticed
until it tried to have 2 x 71's !!
Has anyone had this before / know a reason / know a workaround??
Thanks, Jon 5 3785
Is the Allow Duplicates property for the field set to On?
Pavel
JW wrote: Hi,
This is really weird... I have a database that has an autonumber field. Records 1-70 were deleted. Various things have changed to the front end and a few extra fields added to the table.
Now Access has decided to re-use 1-70 again!!! however this went unnoticed until it tried to have 2 x 71's !!
Has anyone had this before / know a reason / know a workaround??
Thanks, Jon
Field Size: Long Integer
New Values: Increment
Indexed: Yes (No Duplicates)
Jon
"Pavel Romashkin" <pa************ *@hotmail.com> wrote in message
news:3F******** *******@hotmail .com... Is the Allow Duplicates property for the field set to On?
Pavel
JW wrote: Hi,
This is really weird... I have a database that has an autonumber field. Records 1-70 were deleted. Various things have changed to the front end
and a few extra fields added to the table.
Now Access has decided to re-use 1-70 again!!! however this went
unnoticed until it tried to have 2 x 71's !!
Has anyone had this before / know a reason / know a workaround??
Thanks, Jon
I had this happen for no apparent reason a few months ago. The
autonumber skipped some numbers, then went back and used the lower
numbers and generated errors when it reached the higher number and
tried to use it twice.
I had not deleted a batch of records, however I do delete records one
at a time fairly often to correct user entry mistakes.
I fixed this by copying the table, deleting and re-inserting the
autonumber ID field, and re-naming the table to the same name as
before. I don't use the autonumber field for anything, it's only for
the database to use internally, so this didn't cause me any problems
with links or othe number applications.
Another approach might be to copy the table into Excel, fix the
numbers, then copy it back into the table.
Julia
"JW" <jon_webb@#NOSP AM#yahoo.com> wrote in message news:<bn******* **@sparta.btint ernet.com>... Field Size: Long Integer New Values: Increment Indexed: Yes (No Duplicates)
Jon
"Pavel Romashkin" <pa************ *@hotmail.com> wrote in message news:3F******** *******@hotmail .com... Is the Allow Duplicates property for the field set to On?
Pavel
JW wrote: Hi,
This is really weird... I have a database that has an autonumber field. Records 1-70 were deleted. Various things have changed to the front end and a few extra fields added to the table.
Now Access has decided to re-use 1-70 again!!! however this went unnoticed until it tried to have 2 x 71's !!
Has anyone had this before / know a reason / know a workaround??
Thanks, Jon
I did the same (ish) t ofix it - I just wandered why it happened and how to
prevent it!!
Jon
"Julia Baresch" <jb******@oldre public.com> wrote in message
news:50******** *************** ***@posting.goo gle.com... I had this happen for no apparent reason a few months ago. The autonumber skipped some numbers, then went back and used the lower numbers and generated errors when it reached the higher number and tried to use it twice.
I had not deleted a batch of records, however I do delete records one at a time fairly often to correct user entry mistakes.
I fixed this by copying the table, deleting and re-inserting the autonumber ID field, and re-naming the table to the same name as before. I don't use the autonumber field for anything, it's only for the database to use internally, so this didn't cause me any problems with links or othe number applications.
Another approach might be to copy the table into Excel, fix the numbers, then copy it back into the table.
Julia
"JW" <jon_webb@#NOSP AM#yahoo.com> wrote in message
news:<bn******* **@sparta.btint ernet.com>... Field Size: Long Integer New Values: Increment Indexed: Yes (No Duplicates)
Jon
"Pavel Romashkin" <pa************ *@hotmail.com> wrote in message news:3F******** *******@hotmail .com... Is the Allow Duplicates property for the field set to On?
Pavel
JW wrote: > > Hi, > > This is really weird... I have a database that has an autonumber
field. > Records 1-70 were deleted. Various things have changed to the front
end and > a few extra fields added to the table. > > Now Access has decided to re-use 1-70 again!!! however this went unnoticed > until it tried to have 2 x 71's !! > > Has anyone had this before / know a reason / know a workaround?? > > Thanks, Jon
As far as I know it's just random corruption. It happened just before
I implemented a front-end back-end split, and one of the reasons I did
the split was to help prevent corruption. Before the split we had
corrupted records or fields every few weeks, and this was the third
corruption problem that surfaced while I was working on the split.
We haven't had nearly as much corruption since the split, in fact, I
can't remember having any. The split also prevented that annoying
"form has been changed" message when all users were in the same forms.
"JW" <jon_webb@#NOSP AM#yahoo.com> wrote in message news:<bn******* ***@sparta.btin ternet.com>... I did the same (ish) t ofix it - I just wandered why it happened and how to prevent it!! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Tony Williams |
last post by:
I have a table called tblseries with a field NextNumber
I also have a form called form1 based on table1 On the form is a control
NNum which I've called NNumtxt with the following code in the BeforeUpdate
Property =NewNbr()
NewNbr is a function in Module1 the code for the function is this
Function NewNbr() As Integer
Dim rst As DAO.Recordset, db As DAO.Database
Dim lngNextNumber As Long
Set db = CurrentDb
|
by: deko |
last post by:
Is there a way to reset the AutoNumber sequence?
I have several tables that use the AutoNumber field as the Primary Key, and
I'd like to somehow do an Import/Export that will make remove the breaks in
the sequence. A few breaks in sequence is not a big deal, but I have one
table with under 200 records, but the last AutoNumber PK ID field is over
1500 - due to a lot of edits....
|
by: Alan Carter |
last post by:
http://www.mvps.org/access/tencommandments.htm
Thou shalt not use Autonumber if the field is meant to have meaning for thy
users.
Why?
Alan
|
by: Ed Havelaar |
last post by:
Hi,
Hope someone can help. Here's the scenario:
I have two MSAccess tables MainTab and SubTab. MainTab has an autonumber
'id' column as primary key. Subtab has this id column as a foreign key.
There is a one-to-many relationship defined on MainTab and Subtab using the
id column. The join type is include all from MainTab and only rows with
matching value from SubTab. Referential integrity enforced; cascading
|
by: heather e blair |
last post by:
I have a table where the key field is an autonumber. The highest number
was about 900, and there are several gaps in the sequence. This database was
recently converted from Access 97 to Access 2002/XP
At some point, it started using low numbers for new records. I compacted the
database, and it's still doing this.
Is this a problem? Will it start overwriting the high numbers when it gets
to them?
| |
by: MLH |
last post by:
I have an A97 database table (tblCorrespondence] in a database
installed at 2 sites. The table's key field is not a
natural key - its an autonumber field. Here are the values at the
2 sites. First, site #1. Then, site #2. If you plot them, you'll see
why I'm worried - I'm afraid I'll be running out-a-numbers soon.
For the life of me, I have no clue why they're not incrementing
by 1. Hope someone can help.
Site #1
|
by: jason.teen |
last post by:
Hi,
Curerntly I have designed my table in MS Access with a column of
"RuleID"
and is set to (autonumber)
tblRule:
RuleID | Name
-------------------------------
1 | One
|
by: Alan Mailer |
last post by:
A project I'm working on is going to use VB6 as a front end. The back
end is going to be pre-existing MS Access 2002 database tables which
already have records in them *but do not have any AutoNumber* fields
in them.
Correct me if I'm wrong, but I'm assuming this means that I cannot now
alter these existing Access tables and change their primary key to an
"AutoNumber" type.
If I'm right about this, I need some suggestions as to the...
|
by: Gogo |
last post by:
Database has record 59 showing, tabing to enter data returns
autonumber to 134. What happened to cause this, how would I fix it?
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |