Search results

I am very interested in the topic of communication between Vba and an opc server Where can I find the correct library?

What exactly is the purpose of all these considerations? I don't see any useful indication to clarify the question posed initially

You don't need to repeat it, it's perfectly clear And indicating the size of the largest file you've worked on is of no use in understanding how to deal with the problem I asked how to organize a project (also understood as a set of multiple Access files or similar) so that it can grow in size...

No, the final size is not known

The question is: how to organize a project to avoid it reaching dimensions incompatible with the limits of the development environment All other considerations are useless

This means that the project grows by adding new forms and reports and code, after being released.

Sometimes these are projects with a few dozen forms, tables, and some code modules But sometimes we are faced with projects that have hundreds of forms, hundreds of reports, dozens of modules even with a lot of code, and in this case we often get close to the limits of the Access environment...

Ok, then a 'master' used only as a template And each user who uses their own copy from their own directoryes Everyone who communicates via odbc with the only existing dsn and the only existing db

Many thanks for the always useful technical advice Maybe you didn't read that Erp2.accde contains only the code, while the data is on a Sql Server So basically you say that it is better to make many separate directories like: c:\public\erp1 for user user1 c:\public\erp2 for user user2 ...

Ask where they got this information

I have a computer that we will call PC1 that installs Windows 2022 server as the operating system The terminal server service has been activated on this PC There are 10 different users on PC1, user1, user2, user3, ... In the directory C:\PUBLIC\ERP2\BIN there is the ERP2.ACCDE file created with...

An odbc connection It would allow us to 'talk' to all the db's in this universe I'm not up to date, can it be done already?

So far, however, nothing working has been seen 'connected' to a database.

If client stop with any error non recoverable, there is not a 'close' for that client

This is ONE possible solution Also Kitayama is a possible solution, maybe better, who say

The best solution I've found so far has been to add an 'AvailableClients' table to the database, each client that is started checks if the record with its IP address is present, if not present then it adds the record Each client, when started, uses the MSWinsockLib to listen for a tcp socket...

Or JoaX Average user 🤣

No The question is: "..How to detect (from any workstation) which workstations have the Access program.." Firebird, Sql Server, Postgresql, doesn't matter

For those who have actually used one of these ready-made virtual machines, do you know if they have an 'expiration date' or in any case a time limit beyond which they can no longer be used correctly?

If you want to completely free yourself from the Access code for sending emails, I recommend SwithMail You prepare a text file with the commands to pass to the program and then start it with vba shell command The entire task will be delegated to the operating system and the flow of your code...