Can't add record into table

[bxgirl]

I have a simple table setup with a primary key whose dataType is set to autonumber. I simply open the table and each time I try to add a record, instead of the primary key incrementing it takes a preexisting id. So i can't add a new record. I notice a + sign to the right of the rows which my other tables don't have.

Any reason why this would happen?

 

[ssatech]

Why would you be entering data directly into a table?

Have you tried creating a new table with same fields and testing if this still happens?

 

[TheAceMan1]

How are ya bxgirl . . .

It appears you have corruption of some kind! . . . Try Compact & Repair and see if that helps!

See Ya! . . . . . .

 

[bxgirl]

ssatech, I tried to enter data thru one of my forms when I rcvd an error message about a duplicate key. So I went thru the backend and tried entering a record and noticed what was happening. Yes I have tried this with other tables and it worked. It use to work with this table.

TheAceMan1, I'm doing fine here in the boogie down. I tried the compact & repair...no luck.

 

[RoyVidar]

It's probably this bug witht the Autonumber field

http://support.microsoft.com/default.aspx?scid=kb;en-us;884185.

There's a suggestion of solving within the link (you might need to remove the relationships temporarily when applying it, though)

Roy-Vidar

 

[bxgirl]

Thanks RoyVidar, I'll try that.

 

[fneily]

The + sign in your table indicates a subdatasheet. When you click on it, it will show the corresponding records in another table that it is related to. When you create relationships between tables in the relationship window, Access 2002 and higher automatically puts the + sign there. So you're probably trying to insert a new record against the rules of referenial integrity. Thus the error. You can break the relationship it's connected to. Then you'll probably be able to add the new record. Or you may have Click Insert - Subdatasheet.