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
Free Microsoft Office Documents Recovery
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 or email me at mikesv@inbox.com
Thursday, March 11, 2010
COUNTER PRIMARY KEY
Labels:
Access 2007