Hello,
I am using Windows 98 and Access XP and I have noticed the following
strange thing. When I add a new record to a table, sometimes the
counter is correctly set to the highest counter in the table plus 1,
sometimes it is set to 2, 3, 4, 5, ... even if in the table there are
already this counter values. In this last case, in fact, it is
generated a duplicate key error.
The properties of the counter field are set to 'Autoincrement' and
'Duplicates not admitted' in either cases.
Why does Access behave sometimes in one way, sometimes in another way?
Excuse me for my approximate English!
Thanks,
Giulio Simeone
1  1171 
Here is an article that describes the situation, see if it will help. http://support.microsoft.com/default...roduct=acc2002
--
Wayne Morgan
MS Access MVP
"Giulio Simeone" <vi************@yahoo.it> wrote in message
news:84**************************@posting.google.c om... Hello,
I am using Windows 98 and Access XP and I have noticed the following
strange thing. When I add a new record to a table, sometimes the
counter is correctly set to the highest counter in the table plus 1,
sometimes it is set to 2, 3, 4, 5, ... even if in the table there are
already this counter values. In this last case, in fact, it is
generated a duplicate key error.
The properties of the counter field are set to 'Autoincrement' and
'Duplicates not admitted' in either cases.
Why does Access behave sometimes in one way, sometimes in another way?
Excuse me for my approximate English!
Thanks,
Giulio Simeone This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Anatoly |
last post by:
Hi everybody,
I am writing a scheduling system that has appointments table. For each
appointment I am adding a new record that has EventID and ClientID. Each
event has capacity that needs to be...
|
by: VIJAY KUMAR |
last post by:
Hi pals,
I am using 2 web forms (pages). In first page, i have Datagrid control
and on second page i have a hyper link control to the first page and Add
value to the data grid/Database.
...
|
by: -:= Cactus |
last post by:
Hi!
I've made a form for dataentry in a simple table. However when there
are records in that table and I open the form it only displays the new
(blank) record. The total number of records is 1,...
|
by: JN |
last post by:
Hi all,
I have some pages where I need to delete/update database
records. Everything is fine until I hit the refresh button
on the browser (IE). This will cause the pages to repeat
the last...
|
by: Rudy |
last post by:
Hi all,
I know this is easy, just can't seem to get it. I have a windows form, and
a text box, with a value already in it. I need to add that value to a table.
It's just one value, so the entire...
|
by: Ron |
last post by:
Hi All,
Using Access2000, winXP.
Table 1 = tblClients displayed on frmClients via qryClients. 2nd table =
tblInvoices shown on frmInvoices via qryInvoices. 2nd table = tblDetails
shown on...
|
by: radio1 |
last post by:
Configuration: Access 2002 and SQL Server 2000 using a .ADP Project.
I would VERY MUCH appreciate anyone's input into this problem I'm having.
I have a form in Access that does not permit...
|
by: netchtech |
last post by:
Hi,
I have a record register where I manage records. My problem is that I dont know how to add records to my register. This is the struct I have created that works just fine, so does modify and...
|
by: vbDavidC |
last post by:
I am adding a new record to a table via a dataset/adapter.
I have got the following to work for me but I am wondering if there is
a better way to do this.
I am having to have something in my...
|
by: darrel |
last post by:
HI vb Wizards, good day, just wanted to ask if somebody there can help me iwth my problem. Am having difficulty in adding up records in my table, the table is in Microsoft Access format.
It Like...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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,...
|
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...
| |
