I'm keep forgetting how to add an autonumber or record number to a table in ms access and it is different from t-sql:
docmd.runsql "ALTER TABLE tmp ADD COLUMN id COUNTER PRIMARY KEY ;"
this site was helpful: http://sqlzoo.net/howto/source/z.dir/tip000001/access
Thank you for visiting my blog. It is all started with Microsoft Word/Excel document recovery method that I implemented at work. My coworkers were so impressed that they “forced” me to create a webpage and post steps required for that method. Later I realized that not many people are reading this blog and I decided to keep it for myself and post here some code and ideas that I could reuse for the future. If you find my posts useful drop a comment for me.
Thursday, March 11, 2010
COUNTER PRIMARY KEY
Labels:
Access 2007
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment