Search results

It should be mentioned that SQL Express does not include SQL Server Agent. You have to script database maintenance and backup yourself. That's a disadvantage in a professional environment.

I assume that ‘static class’ here refers to a class whose ‘VB_PredeclaredId’ attribute is set to ‘True’? For the sake of simplicity, I always refer to it as a ‘static class’ too. But technically speaking, it is simply a class of which a default instance exists in VBA, which can be used simply...

When an event such as 'On Load' of a form is raised, you can not only respond to it using code in the corresponding module of the form (Code Behind Form) (in which case the event property would contain '[Event Procedure]'). You can also enter the name of a function with the corresponding scope...

If you use a PowerShell script you could sign it with a certificate and thus protect it against execution if it has been modified.

No, sorry for not specifying that. We use a self-created EXE (C#) as a startup program for our Microsoft Access application. This ensures that the necessary files are copied from the network to the client, searches for/finds the installation location of MsAccess.exe, checks whether it is 32-bit...

But if neither of them is on the client yet, then no. A script or an exe file can specifically address this case. But okay, it all depends on the environment you find at your customers' premises.

The reason we value a decompiled version of the accdb is that we have had problems in the past when different versions of Access were running on the clients. Some locations were unable to use the precompiled code of a (non-decompiled) accdb and refused to run but threw errors. With a decompiled...

In my opinion, the biggest disadvantage of a loader access database is that you first need to have a running Access environment on the client, otherwise nothing works. With a batch file or your own exe (which is how we do it), this is not necessary. In addition, we always copy the front end...

In a domain you can add trusted locations also via group polices (some of our customers do that). ;)

That's a good point. :)

Maybe the version of Windows 11 makes a difference? I've in my mind that 24H2 is more buggy than others...

I don't want to make it unnecessarily complicated, but I haven't even mentioned my operating system yet. However, I use Win 11 23H2, not Win 10. ;)

@KitaYama : Simply waiting a few seconds more instead of executing "Set acc = Nothing" doesn't help too? So the variable has definitely to be set to Nothing?

No flashing/flickering of control tip texts on form "frm_Edit_Publications" here on Access 2019 64-bit fully patched.

@Gasman: I just checked the minimal code @CJ_London provides in #4 that doesn't contain GetSystemMenu.

I'm running Access 2019 Version 2507 (Build 19029.20208) 64-bit. I have a self made Microsoft Access AddIn active and two VBE AddIns (MZ-Tools and another self made one). Also I have an anti virus software (ESET Endpoint Antivirus) running in the background. I tested your code from posting #4...

Is there a form background image? I mean to remember that it could cause flickering.

@CJ_London : - Maybe you have any Microsoft Access Add-In installed which causes this behaviour? - Or can you disable any anti-virus software and test again?

That is incorrect and often misunderstood. The name “Win64” is misleading. It refers to the bitness of Microsoft Office, not Windows. ;)

Since you are talking about the desire for a more stable ODBC connection or improved behavior of Microsoft Access in the event of a connection loss, hasn't this already been improved since Access 2019...