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.)
--
Joe Fallon
Access MVP



"Albert" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 !

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.

--
HTH
Van T. Dinh
MVP (Access)



"Albert" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 !