Top "Autonumber" questions

How to create an AutoNumber field value in Access?

I'm trying the following: CREATE TABLE Table1 ( RecordNo autonumber, --error here! PersonId varchar(50), ... ) But, there is an error. How can …

ms-access autonumber
Using Autonumbering in Access - INSERT statements

I'm having trouble running an INSERT statement where there's an autonumber as the PK field. I have an Auto-incrementing long …

sql ms-access insert ado autonumber
Oracle: auto-increment trigger.

Found the following trigger in a database which was blocking inserts on a unique varchar primary key CREATE OR REPLACE …

oracle triggers autonumber
Can I edit AutoNumber Column in Access?

I've lost my data in Access base, and I've manage to bring them back but when I copy the values …

database ms-access database-design autonumber
How to reset an Access table's AutoNumber field? (it didn't start from 1)

I have a INSERT INTO ... SELECT statement that copies data from one table to another. The thing though is, the …

sql ms-access sql-insert autonumber
Is Access's AutoNumber (Increment) guaranteed to increment?

For a particular table, I have my ID field set to AutoNumber (Increment). If I add 5 rows to this table …

ms-access auto-increment autonumber
How to Auto-number Repeating sections in InfoPath 2010

I have several rows in my InfoPath form initially arranged in a table. Afterwhich, I've a repeating section consisting of …

infopath2010 autonumber
Keep value of autonumber column when importing into Microsoft Access database

What I try is to import several tables programmatically from Microsoft SQL Server to Microsoft Access. Each SQL Server table …

sql ms-access identity autonumber