By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,071 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

error when trying to add record to Access 2000 db

P: n/a
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
relationships.

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?
Thanks,
Frances
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.