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

    Question Unanswered: Calling MS Access function from DTS

    Does anyone know if you can call an Access function from DTS?
    I'm trying to delete data from an Access database, Compact the database, and load new data. My snag is calling a function in Access to compact the database.

    Suggestions?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I don't think you can actually call Access code from within DTS, but since DTS effectively is VBA, you can write VB code that will do the same thing using ADO from within DTS.

    -PatP

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Sounds like using a nuclear bomb to kill a mosquito....

    Maybe a bat file that launches a different access database, then uses autoexec does the work then closes...

    I would probably do this is a sproc with bcp as well, and have the job scheduled...

    What's the source of the data?

    Where do you ski, or is it just a nickname?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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