How Sql Server can interact with Microsoft Access (or other application) ? (1 Viewer)

[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.

 

[amorosik]

No, I just tried it and it doesn't seem to work.
I tried with a virtual machine on which I shared c:\driver
And when I set the local program to \\pc2\driver (or even \\pc2\driver\ ), it doesn't seem to 'see' the changes.
It seem that wmi cannot monitor remote share

 

[xavier.batlle]

You are right! It doesn't work on a shared folder!

 

[xavier.batlle]

No, I just tried it and it doesn't seem to work.
I tried with a virtual machine on which I shared c:\driver
And when I set the local program to \\pc2\driver (or even \\pc2\driver\ ), it doesn't seem to 'see' the changes.
It seem that wmi cannot monitor remote share

Wait! It works for me if I assign a letter to the shared folder: