Geek Answers Handbook

Read Access Database from WIX Installer

Can I read the access database when starting the installer embedded in WIX? I see that there are parts of SqlExtension and UtilExtension, but all the examples seem to consider it to be an SQL database. I would like to read the records from the table during installation and for each record, request an installer for the data. I assume that I can search for files to find the location of the MDB, and I will find out the password needed to access the read table.

I did not use a lot of WIX, so any help on this would be appreciated.

+4
source share
2 answers

Since Wix SqlExtension does not allow you to set the type of provider, I doubt very much that this is possible. Also, you will not be able to program and query the user for data in the Wix installer, since AFAIK is not supported (well, I never developed how to do this!).

Depending on what you are doing with the data you want to query, you have several options.

  • If you need to save the data back to Access Db, I would say that your best option for this is to enable the data setting the first time you launch your application (or create a one-time launch setup application) and use wix to automatically start at the end of it at the end of your installation .
  • The second option is to use Burn to create a more user-friendly .net-based installer that downloads the msi created in your application, at the same time capturing the data you need and doing everything you need to do this.
+2
source

You can write a custom action to query the MDB and set the MSI properties. You can then use the thoses properties in the registry entries.

+1
source

More articles:


All Articles