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]

Re: Access DB - Autonumbers?


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" <julie@home.com wrote in message
news:elVXJZ8zHH A.4184@TK2MSFTN GP06.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.
>