none
How to include Access 2007 as a prerequisite

    Question

  • Hi,

    I know that I must include the executable for Access 2007 (from the MS Website) in my setup project as a prerequisite. My question is how? It isn't in the list of prerequisites that I find in the setup project. Where should I define it as a prerequisite and then how do I include it in my setup.exe? Thanks, Jim

    Tuesday, November 22, 2011 9:57 PM

Answers

  • I'm pretty sure you can't do that. Access 2007 is part of Microsoft Office, and you can't start giving away Office in your install.  To access an Access database there's a Jet Engine redistributable, look at that, or the "Access Database Engine".
    Phil Wilson
    Wednesday, November 23, 2011 12:34 AM
  • Addition to Phil, if the requirement is just use the database feature, then the Access Database Engine is enough for you.

    AccessDatabaseEngine: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

    Or you can try the Access Runtime : http://www.microsoft.com/download/en/details.aspx?id=4438

    Then you can make a bootstrapper through Bootstrapper Manifest Generator: http://www.code-magazine.com/article.aspx?quickid=0703072&page=6

    You can use the condition to check if the end user system has Access component, if there isn't, then install this Access Runtime, otherwise please do not install it. Please note that we should check if there's the Access component, not the Access Runtime, since it seems there would be problems if there's a Access and you keep install the Access Runtime.

    When you have any Bootstrapper Manifest Generator tool questions, you can use this forum: http://archive.msdn.microsoft.com/bmg/Thread/List.aspx

    If there's any concern, please feel free to let me know.

    Best wishes,


    Mike Zhang[MSFT]
    MSDN Community Support | Feedback to us
    Wednesday, November 23, 2011 3:56 AM
  • Hi,  It was just too huge of a problem to include Access as a prerequisite to the install. The complexity of what the recommended solution was meant it would take me another week to learn the packager language and oddities. So I opened my application code and did a check for the Microsoft Access 2007 runtime presence. If not present I did an install within my application. However, if I ever get enough time I'll try to learn the language and techniques.  Microsoft just needs to make it easier instead of inventing new solutions. Just create an add function in VS2010 to add prerequisites in the list of prerequisites.  After all, it's even their product.  Jim
    • Marked as answer by jpalatine Monday, November 28, 2011 4:06 PM
    Monday, November 28, 2011 4:06 PM

All replies

  • I'm pretty sure you can't do that. Access 2007 is part of Microsoft Office, and you can't start giving away Office in your install.  To access an Access database there's a Jet Engine redistributable, look at that, or the "Access Database Engine".
    Phil Wilson
    Wednesday, November 23, 2011 12:34 AM
  • Addition to Phil, if the requirement is just use the database feature, then the Access Database Engine is enough for you.

    AccessDatabaseEngine: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

    Or you can try the Access Runtime : http://www.microsoft.com/download/en/details.aspx?id=4438

    Then you can make a bootstrapper through Bootstrapper Manifest Generator: http://www.code-magazine.com/article.aspx?quickid=0703072&page=6

    You can use the condition to check if the end user system has Access component, if there isn't, then install this Access Runtime, otherwise please do not install it. Please note that we should check if there's the Access component, not the Access Runtime, since it seems there would be problems if there's a Access and you keep install the Access Runtime.

    When you have any Bootstrapper Manifest Generator tool questions, you can use this forum: http://archive.msdn.microsoft.com/bmg/Thread/List.aspx

    If there's any concern, please feel free to let me know.

    Best wishes,


    Mike Zhang[MSFT]
    MSDN Community Support | Feedback to us
    Wednesday, November 23, 2011 3:56 AM
  • Hi,  Sorry about the confusion: all I need is Access 2007 runtime engine that is freely distributable. I do have the executable for that and have been using it for years as a separate download. I did read all the bootstrapper data you referred me to. It appears to be for VS2008, I am using VS2010.  But it did overwhelm me. I cannot figure out how the bootstrapper manifest builder interacts with the setup project that VS2010 builds. To my simple way of thinking all I need to do is ask the question : Is Access 2007 Runtime installed, if not then go to the Microsoft website, download and install.  Using the manifest generator it seems I would have to duplicate everything that VS2010 does already then add commands for Access. Help please.  Jim
    Wednesday, November 23, 2011 2:47 PM
  • For Visual Studio 2010, we just can use this place: C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bootstrapper\Packages
    Mike Zhang[MSFT]
    MSDN Community Support | Feedback to us
    Thursday, November 24, 2011 8:42 AM
  • I am writing to check the status of the issue on your side. 
    What about this problem now? 
    Would you mind letting us know the result of the suggestions?

    Mike Zhang[MSFT]
    MSDN Community Support | Feedback to us
    Monday, November 28, 2011 7:57 AM
  • Hi,  It was just too huge of a problem to include Access as a prerequisite to the install. The complexity of what the recommended solution was meant it would take me another week to learn the packager language and oddities. So I opened my application code and did a check for the Microsoft Access 2007 runtime presence. If not present I did an install within my application. However, if I ever get enough time I'll try to learn the language and techniques.  Microsoft just needs to make it easier instead of inventing new solutions. Just create an add function in VS2010 to add prerequisites in the list of prerequisites.  After all, it's even their product.  Jim
    • Marked as answer by jpalatine Monday, November 28, 2011 4:06 PM
    Monday, November 28, 2011 4:06 PM
  • Some produce has the corresponding bootstrapper but some has not, you can submit your feedback to these web site:

    http://connect.microsoft.com/VisualStudio

    http://visualstudio.uservoice.com/forums/121579-visual-studio-ideas

     


    Mike Zhang[MSFT]
    MSDN Community Support | Feedback to us
    Tuesday, November 29, 2011 1:17 PM