HELP! Using ADOX, need DataType 'AutoNum'

HELP! Using ADOX, need DataType 'AutoNum'

Post by Don Hube » Tue, 16 Sep 2003 02:13:14


Using VB6 - ADOX with Microsoft Access 2000
Thru code, I'm creating new DB along with the tables needed for
my project.
Things are OK- I'm able to create the DB,
Im able to create the tables... No problem
EXCEPT ...

I need to create an AUTO INCREMENTING NUMBER
for my first field 'AutoID' in each of my tables
- (also BTW, make it Primary Key)

Having much difficulty in correct VB Code in this specific
area. Can anyone help me out of this little stump !??
 
 
 

HELP! Using ADOX, need DataType 'AutoNum'

Post by Douglas J. » Tue, 16 Sep 2003 02:39:21

Take a look at the sample Carl Prothman has at
http://www.yqcomputer.com/ #Q3

(Just ignore the part about setting the JET OLEDB Engine Type to 4: you'll
want 5 for Access 2000 format)

 
 
 

HELP! Using ADOX, need DataType 'AutoNum'

Post by Don Hube » Tue, 16 Sep 2003 21:22:23

GREAT help !!
THANKS a million !