Really Stuck - Access MDB and Primary Keys

[=?Utf-8?B?Q2hyaXM=?=]

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.

[Ignacio Machin \( .NET/ C# MVP \)]

HI,

"Chris" <Ch***@discussions.microsoft.comwrote in message
news:0B**********************************@microsof t.com...

>I have an MDB database and am using tableadapters, etc. I have the primary
keys in the database as NUMBER (not autonumber).

Why don't you make it as autonumber?
If not you will have to manually assign a value.