I added a registry lookup to display the Access version and error trapping to catch the error. Apparently Access automation from runtime is not allowed.
I just tried it on Runtime. The 1st form opened but Access hung on opening the 2nd db. Ended with a runtime error.
Event viewer showed no error or warning, but this information log.
- System
- Provider
[ Name] Microsoft Office 16 Alerts
- EventID 300
[ Qualifiers] 0
Version 0...
Windows 11 Pro, Version 25H2 (OS Build 262000.7623)
Microsoft® Access® for Microsoft 365 MSO (Version 2511 Build 16.0.19426.20260) 64-bit Monthly Enterprise Channel
In an unrelated note. I do on occasion get the following pop-up error on reboot/shutdown. All programs are closed before the...
A lot of the solid performance could be attributed to OpenVMS. I fondly remember my Novel servers. They never went down and they never slowed down. I hosted Access MDB BE on them and they never got corrupted. The exact same BE never performed as well on Windows Servers.
You are finding that floating point has it's limits. If you are multiplying a long list of floating point numbers, losing precision on each multiplication then at some point nonmatter how many decimal points you have; you will end up with a nonsense value.
AI did find the following support native Quadruple precision.
1. IBM POWER9 and POWER10
2. IBM zSeries (mainframes)
3. Some older HP/Intel Itanium (IA‑64) systems
I have looked and cannot find reference to an Intel Longhorn CPU, but I do remember the name as the code name for Windows Vista. Do you have any other memory of that systems. Would it be something much bigger then a Intel based computer?
Once when archive old quote data because the FE size reached the MDB max, the queries would fail because of transaction limits. I changed to moving 1 quote per transaction. It would also fail after certain number of transactions. I would then restart access and restart the program to continue...
If you looking for high speed data entry, then sub-forms will not be any better. Look at data entry forms, possibly disconnected. Give the user only the fields required allowing head down typing.
Take a look at this article...
Numerical methods is a complex subject. I minored it in school but have not done anything really deep in a long long time. With that said, I would suggest as I would, looking for outside support for an algorithm; AFTER you better define the parameters and limits of the inputs and outputs. In...
Your math is wrong for the types you are using and the result is the error output you see in the form. I would suggest you look into Numerical Methods to come up with an algorithm that will do the calculation to the precision you require.
Remember back in the coming ice age days, some smart scientist suggested coating ice sheets with a dark substance to absorb more heat from the sub:cool:
I agree, AI info can be suspect. But over the years, I have never seen anything that would negate what Copilot reported. In the last 5 months I replaced or update 30 computers using Ninite to install Notepad++. None of those computers show any sign of the corruption.
I posted the following question to CoPilot.
Does Ninite.com suffer from the security issues of Notepad++ updates
This is the response
Ninite.com is not affected by the Notepad++ update‑hijacking incident, because the attack targeted Notepad++’s own update infrastructure—not third‑party...