J.O. Aho (
us...@example.net) writes:
> On 29/07/2021 12.43, Ammammata wrote:
> Hi there,
> this is a MySQL forum and has nothing to do with mssql or ms-access, so
> adding c.d.ms-sqlserver and c.d.ms-access which also been follow-up to.
>
>
>> I'm trying to run MS Access runtime, with my procedure and an additional
>> parameter
>>
>> the command line is
>> MSACCESS.EXE c:\Sviluppo\QCT\QCT1000.mdb ;255
>>
>> without path, being it already included in the PATH variable
In *your* PATH variable. SQL Server runs under a service account, so
it does not have your PATH.
>> If I include the path in the command line
>>
>> EXEC xp_cmdshell '"C:\Program Files\Microsoft
Office\Office16\MSACCESS.EXE"
>> c:\Sviluppo\QCT\QCT1000.mdb ;255';
>> GO
>>
>> it goes into a loop and I have to kill MSSMS to exit
So when you run that command line directly, what happens? Specifically,
does it open a UI?
SQL Server runs as a service and does not have a desktop, so running
anything which has a UI is not going to work out.