Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    1

    Arrow Unanswered: Calling Microsoft Access function from SQL Server stored procedure

    I currently have a number of functions in Access modules that are run as overnight maintenance routines (via third party software). Whilst some of these functions can be rewritten as stored procedures and run as jobs by SQL Server Agent, there are a number that can't.

    Is there any way to run a function in an Access database by calling it from SQL Server?

    We've considered using an Execute Process Task as a local package but this only runs command line code - whilst this can therefore run a specific macro, we would need to install Access on the SQL server, and we would prefer to avoid this.

    Any help would be gratefully received!

    Thanks,
    Simon.

  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    The only way for it to happen schedualed is for access to be on the server. We have run into this problem as well and have found no other way.
    Regards Jim

  3. #3
    Join Date
    Aug 2002
    Location
    UK
    Posts
    87
    Gosh, I'm intrigued by what the modules are doing that can't be done with Transact-SQL scripts.

    Can you set an automated task on a client machine that will run the modules?

Posting Permissions

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