Sandra Smith
asked on
On ACCESS 2010 VBA Create Table statement, need to be sure first filed is autonumber.
The below creates the table, but how to I make sure the first field is autonumber?
CurrentDb.Execute "CREATE TABLE hldIntegerValueModelSS (RecNumber INTEGER, IntegerValue INTEGER)"
CurrentDb.Execute "CREATE TABLE hldIntegerValueModelSS (RecNumber INTEGER, IntegerValue INTEGER)"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Did the job the simplest.
you can also use "autoincrement"
CurrentDb.Execute "CREATE TABLE hldIntegerValueModelSS (RecNumber autoincrement, IntegerValue INTEGER)"
CurrentDb.Execute "CREATE TABLE hldIntegerValueModelSS (RecNumber autoincrement, IntegerValue INTEGER)"
CurrentDb.Execute "(CREATE TABLE hldIntegerValueModelSS ([ID] AUTOINCREMENT, [RecNumber] INTEGER, [IntegerValue] INTEGER)"