Ms Access install if not exist in computer

Question

Hi I have created windows form application based on MS Access 2007 database and created setup file also But the problem is, when install application its through exception if ms access not available in computer Is there any option during installation of my application Ms access should install automatically in pc if its not exist or any other way

that does not seem to have anything to do with programming at all, in particular with neither C# nor winforms. — MakePeaceGreatAgain, Jul 31 '20 at 10:59
Do not use MS Access. Switch to something royalty free. Like SQLite. You cannot just install some MS Product! — Fildor, Jul 31 '20 at 10:59
https://stackoverflow.com/questions/59553365/ace-oledb-connection-to-access-runtime-2016 — CodeCaster, Jul 31 '20 at 11:02

score 2 · Accepted Answer · answered Jul 31 '20 at 11:08

To be able to use an access database file you don't need MS Access be installed on the users machine. That is a paid product, as part of MS Office.
Instead you could download and install MS Access data engine. You could add it as a requirement in your setup (how you do that depends on what you use as installer. With inno setup for example it would look like:

Filename: "msiexec.exe"; Parameters: "/i ""{app}\accessengine\accessenginefilename.msi"" /qb ...;
For what it is worth, if it is not too late for you, instead of access, use some other database, like SQLite, liteDb, ... There are 250+ databases out there to choose from.

Ms Access install if not exist in computer

1 Answers1