Search results

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

Perhaps I'm not using the terms correctly because I'm translating from my native language to English But the key point is that method 2, which I believe to be feasible, cannot be considered "polling," even if the external script were only used to "launch" the function within the Access code and...

"..The "function in Access code" has to check for the message, i.e. polling.." No, it's not a periodic, continuous query It would be about retrieving the information needed to manage the function That's something entirely different, a read performed one time and only when there's actually...

I can't touch the files I'm working on in any way Anyway, yes, the 'hidden' file idea seems like a good idea, I hadn't thought of that.

The files that arrive are the sales invoices that suppliers send us, we have no control over the file type

No, the operations performed by the Access code are irrelevant They could be operations that need to be completed quickly, or operations that can simply be displayed on screen and then the operator can check when they're at their workstation My question is how to get SQL Server to communicate...

No, the important thing is to find a way of asynchronous communication between the database server and individual workstations, a system to alert workstations when something happens to the data. Even how the data is processed isn't important; each workstation could react differently

I don't quite understand this one Suppose there are three workstations, PC1, PC2, and PC3 If PC1 modifies a record in the item table, how would PC2 and PC3 be informed?

So it all seems to be based on this 'service broker' Yes, that's what I was looking for. I'll try to look into it now.

Okay, this could be a possibility

No, polling db is not acceptable

"..this implies either that you will be available and online.." no If the operator is available when the ARTICLES table is modified, the system sends the message to the workstation, the operator can react and perform the required operations If the operator is not present at that time, nothing...

How can SQL Server send a "message" to an Access procedure when a certain condition occurs in the data? For example, suppose we have an ARTICLES table that, in addition to other fields, also has ARTICLES_ID as the primary key Suppose the condition is "any change to a record" Suppose the article...

I don't quite understand one thing Suppose you install it on a local system, within your LAN, then you can use it without paying anything? And then, what's the connection between n8n and the local management system?

Sorry, but I'm still collecting 'saying' What exactly mean "..You have hit the nail on the head.." ?

The latest-generation drives are really very fast Until a few years ago, the disk was the bottleneck, but fortunately that's no longer the case On this laptop, which is nothing special, I divided the main drive into two 500 GB partitions Copying large files (a 40 GB virtual machine) from drive...

Yes, in the example above, the communication is between PCs, or rather between individual modules on the same PC In reality, this is only to get the code working on the client workstations The actual communication is between program X installed on the central server, which sends commands to the...

Yes, like a classic join between two tables I'd like to understand how, and if it's possible, to use an in-memory structure (an array of integers, a disconnected DB ADO recordset, or similar), instead of a database table to create a query or function that returns the same results as a database...