Search results

Yes. I think, you just need to use the full path to MsAccess.exe and it should then also work with the runtime. PS: Keep in mind that VB Script is deprecated and will be removed from future versions of Windows.

Very good. You might need to count either distinct user or distinct remote PID because one Access frontend might use more than one connection.

I'm not familiar with Firebird but a quick look into the docs shows that it is possible to create a database trigger for the CONNECT event. That should allow you to implement my suggestion although you need to work out the details yourself.

You are using SQL Server? Then use a LogOn-Trigger to count the connections grouped by either user or computer name.

So, essentially, your old code still works but (some) new code causes errors? The simple explanation would be that you made errors writing the new code. If you don't think, after thorough review, that this is the case, you should post the code in question.

This sentence is misleading. It should read: "Now the default is to block such queries if the registry key does not exist."

This is good advice. - In theory. In practice however, ... - There is no AD and the client has no desire to get one. - There is not even a network connection from the outside into their local branches, where most of the users are. In general, the client is not very fond of Microsoft and its...

That's a good idea. I didn't yet. I will do so, but I might not have an opportunity until next year. (Users work in a retail shop scenario and at this time of the year they are too busy to allow me to remote into their computers.)

I now implemented a rather crude workaround... I daisy chained multiple approaches to send the email one after the other. 1. I try DoCmd.SendObject, which at least works on some computers. 2. I use arnelgp's Thunderbird command line approach, which surprisingly even works with very long...

I did this already; forgot to mention it. They all have Thunderbird set as Default Email App. (There is no other email app installed.) This settings appears to have little effect. On the one computer where it now works this was set initially, but sending emails with DoCmd.SendObject still...

Yes, it does. This maybe could be an alternative. I'm somewhat reluctant to use this, as the template text of the email is dynamically generated and I cannot be sure whether the total length will be within the limits of a mailto hyperlink.

Hi! At a client there is a problem on *some* computers with DoCmd.SendObject. It fails with the error: 2046 - The command or action 'SendObject' isn't available now. On the affected computers, the Access application runs in Access 2024 32bit on Windows 11 and they use Thunderbird v146 64bit...

You're still mixing up the terms SSMS and SQL Server. SQL Server is the database server and SSMS is its administration tool. - I know what you mean, but other people might be confused if you don't get the terminology straight. You want to install in the customer's LAN, don't you? For a computer...

'Managed Instance' is a term for a SQL Server instance hosted on Azure. On a local server it would just be an Instance. - There are more difference between a local SQL Server Instance and a Managed Instance on Azure, but for now let's not dive that deep. You are basically correct. A SQL...

It is not a good idea to put off these things to "the end". If you plan to work with different user accounts, encryption, and anything else you might want to add, this is something that should be incorporated early. Some of your code will have to be adjusted for that and you should test it...

In your code there is only *one* variable: s. Is it? Yesterday I might have agreed, but today I toyed around with your sample DB and my (preliminary) conclusion is that there is almost no difference between a String and a Variant of subtype String. The only difference seems to be stricter type...

Why do you think that? SQL Server Management Studio to my knowledge neither uses OLEDB nor ODBC. This is expected. The new SQL Server ODBC drivers are not installed on Windows by default.

Is this very, very new news or old news? Microsoft deprecated OleDB around 2015. But in ~2020 they reversed that decision and released a brand new OleDB-Provider for SQL Server catching up on the new features not available in the old OleDB-Providers. So, are you referring to the old, reversed...

Yes, there is an ODBC driver for Access databases you can use to connect from other applications. As you wrote about "linking" to an Access backend: No, you cannot use this ODBC driver to link an Access frontend to an Access backend.

Linking from an Access frontend to an Access backend through ODBC ist not supported.