Results 1 to 2 of 2

Thread: Access

  1. #1
    Join Date
    Oct 2003

    Angry Unanswered: Access

    My question is Access related.
    1) I have an access file with many tables.I want to replicate this access file but without data.Means I want to make a copy of the access file with the same tables with same design but without any data.How to do that?
    2)In one of my DTS data goes from SQL to Access.I want to truncate few access tables before this DTS package is run.It should be done through SQL.How can I do that?

  2. #2
    Join Date
    Feb 2004
    replicate without data? what do you mean? any table change should result in a change on a table in sqlserver?

Posting Permissions

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