Recent content by sonic8

JFTR: VBA does not have garbage collection. Memory for object variables is released based on COM reference counting.

Ok, I misunderstood this, but ... ...actually... I don't think this is a good idea. And I think, you will agree... On my computer a .jpeg file will open by default in an application, which identifies itself as Photos.exe. Now look at the registry key you were referring to:

@KitaYama and @cheekybuddha, I get the impression that you completely skipped an important step: How do you know that Microsoft.Photo.exe is actually the application the user has configured for viewing these types of files? I really wonder why nobody pursued this approach, which, in theory...

@KitaYama , did you notice that the backslashes in the path were replaced with the Yen currency symbol in your screenshot?

...which might also include picture viewer applications the user started independently of the Access app. dllhost.exe may run an wide variety of DLLs for a wide variety of purposes. Not necessarily. See #6.

Good approach in theory. In practice there might be a problem.... The default picture viewer, as defined in the Windows Registry, will often be: %SystemRoot%\System32\rundll32.exe "%ProgramFiles%\Windows Photo Viewer\PhotoViewer.dll", ImageView_Fullscreen %1 However, the actual running process...

Trusted Locations are per Office Application. So, it will not work to use Excel (or Word) to define a Trusted Location for an Access file.

I had the very same problem in the past and wrote on it here: Compiling an Access project with VB-Script

An Access add-in requires more configuration/installation and is prone to problems when run unattended. I would rather use a script to directly set all required properties. You could still use an add-in to create the XML configuration file, but the build process itself should run without an...

@Josef P. , thank you for your work and the posts here. I understand your scripts are customized for GitHub Workflows. Did you also evaluate how this approach can be transferred to Azure Pipelines?

If you combine the three queries into one using a UNION query, as @Gasman suggested, you will get the desired result. With ADO Recordsets it would also be possible to copy the records from multiple recordsets into one new recordset. However, this would be rather slow row-by-row operation. The...

If the suggested solution for timestamping actually ever worked (I strongly doubt it), it should still work regardless of where the certificate is stored. The new (2023) requirement for secure storage is not technically enforced. It is just an agreement by the certificate issuers industry...

It is possible for an organization to create email accounts with a 3rd-party provider and then the user (you) creating a personal Microsoft Account with that email address. But this is rather unusual. Normally, the organization's IT admins would register the domain as a Microsoft 365 Tenant...

Your above statements contradict each other. If the "problem" only exists with your account in yourOrganizationDomain, it is clearly not your private account, but an account set up by your organization for you.

Yes. https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/begintrans-committrans-and-rollbacktrans-methods-ado