This is definitely not the absolutely 'correct' forum, however - general knowledge picked-up, whilst using MS Access may well be contained here.
I work on a site where 'MOD level' security must be applied.
Subsequently, deploying full-featured MS Access applications is a nightmare.
Ensuring that all recipients have the required MS Access installation (individual recipients for a specific app out of many) - with all required .DLL's etc. is a nightmare, followed by regular upgrades wiping out past settings etc.
After a couple of decades of using MS Access, I recently came across a method of interrogating / processing MS Access .accdb tables without having to have MS Access installed on the local computer, by using .HTA (and VB Script). This is possible due to the JET (or ACE) Engine being distributed by default with the Windows operating systems.
I was shocked to learn that you could actually produce a full-blown application, using .HTA and Access DB as the back-end - without MS Access being installed!
(Rather than .HTA - I am leaning toward Visual Studio VB / C# to produce the functionality though).
I have a question where Google is not forthcoming in providing a definitive answer:
Accessing an MS Access produced database (without having MS Access itself installed on the local computer) works fine via VB Script for up to Windows 7.
This is because those Windows versions were shipped by default with the JET / ACE database engine (used by Access and Excel - I believe).
Does Windows 10 continue with that shipment of the ACE database engine, and is that by default?
(If someone can point me to a better-placed forum - please do-so - I'll move it).
You've helped me massively over the last few decades (I'd like to think I've also done the same back).
Hope you can at least point me to a definitive answer - as you always, usually do.
ATB,
Darrylle
I work on a site where 'MOD level' security must be applied.
Subsequently, deploying full-featured MS Access applications is a nightmare.
Ensuring that all recipients have the required MS Access installation (individual recipients for a specific app out of many) - with all required .DLL's etc. is a nightmare, followed by regular upgrades wiping out past settings etc.
After a couple of decades of using MS Access, I recently came across a method of interrogating / processing MS Access .accdb tables without having to have MS Access installed on the local computer, by using .HTA (and VB Script). This is possible due to the JET (or ACE) Engine being distributed by default with the Windows operating systems.
I was shocked to learn that you could actually produce a full-blown application, using .HTA and Access DB as the back-end - without MS Access being installed!
(Rather than .HTA - I am leaning toward Visual Studio VB / C# to produce the functionality though).
I have a question where Google is not forthcoming in providing a definitive answer:
Accessing an MS Access produced database (without having MS Access itself installed on the local computer) works fine via VB Script for up to Windows 7.
This is because those Windows versions were shipped by default with the JET / ACE database engine (used by Access and Excel - I believe).
Does Windows 10 continue with that shipment of the ACE database engine, and is that by default?
(If someone can point me to a better-placed forum - please do-so - I'll move it).
You've helped me massively over the last few decades (I'd like to think I've also done the same back).
Hope you can at least point me to a definitive answer - as you always, usually do.
ATB,
Darrylle
