How Sql Server can interact with Microsoft Access (or other application) ? (2 Viewers)

[xavier.batlle]

Perhaps another approach could be, to create an asynchronous File System Watcher using WMI Events. If the SQL Server is able to create a file in a folder that MS Access is monitoring then the MS Access Application can do some stuff when files are created in this folder
I've never used it but I managed to create this simple example with some AI help
- No polling.
- No timer
- No blocking processes
- It's true async
- Very easy to implement

 

[amorosik]

Do you think remote directories could also be monitored?
I mean, if individual clients monitored a directory that the server uses, then this client-side code would suffice.

 

[xavier.batlle]

Do you think remote directories could also be monitored?
I mean, if individual clients monitored a directory that the server uses, then this client-side code would suffice.

If by "remote directories" you mean, shared folders on the server, sure!
I haven't tried it yet, but I'm sure it will work.