Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Location
    Stavanger
    Posts
    1

    Unanswered: Call a sqlserver function/procedure/jon/dts from MSACCESS

    Hello!

    This is my first posting here and I hope somebody could help me out with this...

    I have created an MSACCESS front-end application with ODBC-linked tables (SqlServer tables) and have made some DTS packages on the SqlServer that would be nice to be able to execute from MSACCESS.

    Does anyone have examples of how to call/execute DTS/procedures/functions/jobs on an SqlServer database from MSACCESS?

    Rune

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Is there a reason you're not using an adp?

    ADP's are the way to go if you intend to be calling SQL Server's functions et al.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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