By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,543 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,543 IT Pros & Developers. It's quick & easy.

Access DB - Autonumbers?

P: n/a
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.
Jul 26 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a

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.

Jul 26 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.