Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    5

    Question Unanswered: Calling Access function from DTS

    Is there a way to call an Access function from DTS?

    Specifically, I'm trying to schedule a DTS package to delete data from an Access database, compact the Access database, and load new data. Calling a function to compact the database is my snag.

    Suggestions?

  2. #2
    Join Date
    Jan 2004
    Posts
    184

    Re: Calling Access function from DTS

    You can run VBScript from DTS. Create a New VBScript, in that VBScript AUTOMATE your Access database. Once you have done that you will have access to all the objects that are in the access database.
    In abundance of water only the fool is thirsty. Bob Marley.

Posting Permissions

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