Search results

I haven't actually tried it yet, but it should be something like this: 1- enable sp_cmdshell 2- add a trigger for the desired events 3- create a batch file to send the command to remote workstations EXEC sp_configure 'show advanced options', 1; RECONFIGURE; EXEC sp_configure 'xp_cmdshell', 1...

Are you saying that /cmd isn't usable if the remote location already has an active Access instance? Yeah, that could be a problem; it makes remoting useless Do you think /cmd is also unusable if the command is started from the local PC, for example, from a batch file? Hey guy, what mean...

What? Do you want to harm me? 🤣

Microsoft Expression Web 4, Adobe Dreamweaver

I add that it seems possible to start a program on a remote PC also using psexec which is a utility of the super famous Sys Internals suite @echo off REM Avvio remoto di erp2_x64.accde su PC2 con parametro set REMOTE_PC=PC2 set USER=NomeUtente set PASS=Password set ACCESS_PATH="C:\Program...

"..execute a remote instance of MS Access Using PowerShell.." What you mean exactly? You say that if on pc1 I have my Sql Server and therefore the script that sends the message, and on pc2, pc3, pc4 I have my erp2_x64.accde program with the Access runtime, is it possible from the script on pc1...

Public Ricevi_Comando(byval command as string) as string Is a function inside a standard module of the erp2_x64.accde program We're freeing the poor worms in the can .🤣 The listener is the one posted above or similar No, there are no local tables, everything is on the database server.

"...So, accept my apologies..."Are you kidding? It's clear that those who respond and spend their time trying to help you don't need to apologize, ever It's a matter of understanding which path to take, and it's not always easy to explain (at least for me) And I also understand that my desire...

It's true that sending emails from SQL Server is simpler, but I understand that a SQL Server trigger can launch a SQL Server job, which in turn can run a PowerShell or cmd script So, on the event source side, I don't think there are any problems (although I haven't actually tried it yet)...

All the points you listed have nothing to do with what I requested Who is making the request, whether there is feedback or not, whether the recipient list can change or not, have nothing to do with the original questione, that is: "...how can we 'notify' the executing Access procedure that the...

Yes, of course, this is hypothesis 2 considered in the post #19 It is certainly the most effective, but also the most technically complex to implement

1- no, the SQL Server code sends the messages to the intended recipients, but it doesn't maintain a queue and doesn't retransmit. 2- yes, the code inside the SQL Server trigger must know which clients to send the message to. 3- no, SQL Server sends and doesn't care who receives. 4- the client...

Polling is not an option when the initial request says "polling is not an option" The real scenario is irrelevant to the problem's solution

No, using Outlook is out of the question; we'd be back to polling

Sorry, I missed your reply about email There's nothing wrong with that. Even an email message would work fine It would be enough to figure out how to get it received by the currently running Access process Basically, the Access process should also contain a pop3 server Is that what you're...

The user's behavior has no bearing on the request The question is: "...how can we "notify" the executing Access procedure that the..." The operator could be at the desk and react in some way to the message Or they could not be there Or the computer could be turned off None of these three...

Welcome to the enthusiast 😁

This one "..you are asking a very BIG ask for Access.." If it had been simple, I wouldn't have asked .😁

I asked a question that seems pretty specific There may be answers that address the issue Or there may not be a solution to what i am asking But what you write is "...but people here do not..." or "...It's just that others here see other roads..." has nothing to do with the problem posed or the...

And one of the information provided is the exclusion of periodic querying of the db server Yes sure But I expressly excluded it from the possibilities