Call an Access VBA module from SQL Server.

  • Thread starter Thread starter Albert
  • Start date Start date
A

Albert

Hi, I hope someone can help me here. We use SQL Server and MS Access.
In SQL Server, I created a socalled "linked server" to MS Access. That
means that one can see tables and queries stored in Access, from
within SQL server.
Note: SQL server is on a Server machine, Access is on a client PC.

Now, would it be also possible to call an Access vba module, from SQL
Server ???

Any tip will be appreciated !
Thanks !
 
I was not able to do it.
I re-wrote the Access functions as SQL Server UDFs (User Defined Functions.)
 
Slightly different from Joe: I didn't think it is possible so I re-wrote my
Access UDFs to MS-SQL Server UDFs from the start.

I cannnot find anything about using VBA UDFs in SQL Server in a number of
books I read. In addition, I don't think SQL Server is design as a "Client"
to be able to use objects from (automation) Server.

Actually, it is quite a good exercise to translate VBA UDFs to SQL Server
UDFs.

Another possibility is to use a Pass-Through Query to retrieve required data
only and the use this PTQ as the Source for a normal Query in which you can
use your VBA UDFs.
 
Back
Top