Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    8

    Unanswered: Adding a index automatically...

    Hi, still new to all this I'm afraid! I've created a DTS routine that copys some table data from an Access database into another Access database. In the second mdb, I would like the routine to add an ID field and populate all the lines. I'm sure it must be kind of easy but I can't find how!

    Any help appreciated.

  2. #2
    Join Date
    Sep 2003
    Posts
    8

    Cool

    Ah sorted - just added the ID as an Identity when the table was being created in the routine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •