Access DB - Autonumbers?

[Julie Smith]

Hi,
I have a question about autonumbers in Access db. How are they assigned when
adding a new row to a table?

I have table that has an autonumber column (replication ID/System.Guid) and
a name column. When making a new row, I assign the name, then add the row to
the table. I would have thought that the autonumber would be automatically
given, but this does not seem to be the case.

Can anyone help me?

Thank you in advance.

[sloan]

In Access 2000.

I created a User table.

UserUUID = AutoNumber, ReplicationID ( indexed no duplicates)
LoginName = Text 50 (default)

When I do this, and add a new row, I get a fresh guid in the UserUUID
column.

How are you adding the row? Code?

.........

"Julie Smith" <ju***@home.comwrote in message
news:el**************@TK2MSFTNGP06.phx.gbl...

Hi,
I have a question about autonumbers in Access db. How are they assigned
when adding a new row to a table?

I have table that has an autonumber column (replication ID/System.Guid)
and a name column. When making a new row, I assign the name, then add the
row to the table. I would have thought that the autonumber would be
automatically given, but this does not seem to be the case.

Can anyone help me?

Thank you in advance.