make table query unique id

  • Thread starter Thread starter MVM
  • Start date Start date
M

MVM

How do I add a unique ID to a table when I am using a make table query in an
Access project database?
The database is rebuilt every evening so I can't define it in the table
designer.
Thanks,
MVM
 
I dont' know any way to do it during the make-table, but I would add the
field (as an auto-number primary key?) programmatically after the make-table
query runs. Search the access forums for "Add field programmatically" and you
should find lots of info on how.
 
Back
Top