470,850 Members | 1,029 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,850 developers. It's quick & easy.

error when trying to add record to Access 2000 db

Hi All,

I'm having a problem trying to add a record to a simple Access 2000 db
(db is very similar to an address book but with more info than the
usual address, phone, etc.).

The database is one table, 36 fields. The record_id field is an
autonumber field (long int) and primary key. The rest of the fields
comprise of 30 text fields, 3 memo fields, 1 date field and 1 currency
field. Text fields vary in number of characters allowed. All fields,
with the exception of record_id, are set like this: Required = No;
Indexed = No OR Indexed = Yes (Duplicates OK).

The form is all text fields, no controls, combo or list boxes. There
are 3 forms that point to the one table as its source. Only one form
can be open at a time and none of the forms have subforms. New
records can only be added to the "main form."

When I add a new record in the "main form," I get an error message
when I try to move to another record or click New Record to add
another record:

"The changes you requested to the table were not successful because
you would create duplicate values in the index, primary key or
relationships. Change the data in the fields that contain duplicate
data, remove the index or redefine the index to permit duplicate
entries and try again."

I've checked the indexes (all are set to "no" or "yes (duplicates
ok)"), the primary key cannot be a duplicate because it is autonumber
with increment and since I only have one table, I have no

The database stopped accepting new records at record id# 1131.
Correct me if I'm wrong, autonumber should be able to go to higher
numbers? I've tested the autonumber function and it's working. I
reset the autonumber to start at 1200 and it still wouldn't accept new
records. I can edit and view existing records and run reports on
existing records. I just can't add or save new records. There's
plenty of harddrive space and memory.

Any suggestions?
Nov 12 '05 #1
0 2580

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Colin Graham | last post: by
1 post views Thread by MyndPhlyp | last post: by
2 posts views Thread by Chris Taylor | last post: by
6 posts views Thread by rn5a | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.