Really Stuck - Access MDB and Primary Keys

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an MDB database and am using tableadapters, etc. I have the primary
keys in the database as NUMBER (not autonumber). When you hit the ADD button
on the datanavigator, it of course selected what it thinks is the next key.
But when I go to save the record, it fails. Access won't take the new key
even though that key is not in the current database (but was once used and
deleted).

I am so confused about what to do here. Any help would be apreciated.
 
HI,

Chris said:
I have an MDB database and am using tableadapters, etc. I have the primary
keys in the database as NUMBER (not autonumber).
Click to expand...

Why don't you make it as autonumber?
If not you will have to manually assign a value.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MDB file and Primary Keys 2
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
LINQ and "Primary Key Violation" 3
Primary Key Count 3
Simple Typed DataSet Primary Key Question 9
Access Access Record Order 0
Mismatch between foreign key and primary key is not detected 4
How can I Manually Change Access Primary Key ID Fields ? 2

Back
Top