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.