Autonumbering

[dgustin]

I was working on a database and it was autonumbering just fine. when i went
to open it up the autonumbering was disabled. how do i turn that fuction
back on??
I have tried changing the data field from number to autonumber and i get a
error message that reads:

Once you entered data in a table, you can not change the datat type of any
field to autonumber even if you haven't yet added data to that field.

Add a new field to the table, and define its data type as autonumber
Microsoft office access then enters data in the autonumber field
automatically, numbering the recordsconsecutively starting with 1.

 

[Douglas J Steele]

What do you mean by "disabled"? Are you saying numbers were no longer being
generated?

 

[dgustin]

nope, i have to go in manually and insert the numbers

 

[Douglas J Steele]

I've never heard of this before!

So you're inserting values into other fields in the table, the new record's
getting saved, but the Autonumber field isn't getting a value in it?

 

[dgustin]

it saves the record but it doesn't input a autonumber

 

[Ken Snell [MVP]]

How many fields in the table have Autonumber as the data type? Which field
or fields is/are the primary key for the table? Provide the full details
about this table's structure: names of fields, data type of each field,
field size of each field.

And to confirm, if you enter data into the table, this autonumber field
isn't automatically assigned a value -- you're not talking about entering
data via a form, right?