Search results

The question isn't about which algorithm is better than another; it's clear that optimized code is faster than code that's just written the first time But that's not the question The question is "...which hardware/software guarantees better performance for an Access procedure..." Where with...

Just search, anyone can scroll through the posts of any user and check for themselves

A poor design will benefit from improved hardware performance just as much as a good design

It's best to remind Isladogs of this, I was simply responding to his comments.

It depends on how you connect the Arduino board to the outside world If you connect via Wi-Fi and associate a fixed IP address with the board, the board effectively becomes a web server, which you can query from Access with an HTTP GET request Better still, if you install an MQTT client on the...

Ok, 3x

So there are two of you who can't see well

That you're wrong is sure "..I have never seen..." yes, maybe you're not seeing clearly

Of course, I wrote about this function How to create a similar functionality in house

Why do you think I don't put into practice the advice that I think solves the question asked? Also, why do you think a theoretical exercise is less important than something you actually use in some application?

I use MZ-tools, and one of the features I use most frequently is adding error routines, line numbering, and line de-numbering Many forum users will surely be familiar with Mz-Tools, as it's a truly useful tool How can I achieve the same effect (inserting a few lines of code with variables taken...

1 second from better cpu 1 second from better disk 1 second from better s.o. are 3 second !!!

Yes, sure But only focused on Microsoft Access, wich hardware+software combination?

Ok, i write Sql Server + odbc only for define a system But for Access code? Which hardware+software system reach the better performance?

Let's assume that the RAM is sufficient to completely contain both the operating system and all the applications currently running.

Let's assume that the Access procedure is running on PC1, which accesses data on the locally installed SQL Server, through the ODBC driver

You say that the same procedure on Access 64bit is faster then 32bit version? Mmmm... What mean exactly "P2 hard drive" ? Fast single core cpu, then for Windows actually Intel i9 285K is the best?

What PC hardware/software is needed to run Microsoft Access quickly? Suppose Access is the only application running on a computer What hardware, operating system, and configuration is recommended to maximize the performance of the running application?

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

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.