VSTO & MS Access

I'm just trying to get up to speed on the new Visual Studio 2005 and the new Tools for Office.  We do a lot of work with MS Access (and Excel) and what I find odd is that in all the articles I've read there is not mention of MS Access w.r.t. the VSTO.  Do the VSTO not work with MS Access   What am I supposed to use if I am doing development with Access 2003

Can someone please clarify how VSTO works with MS Access   We've already been burned by buying Visual Studio 2003 "Special Edition".  It includes the Office Tools that I believe work with Excel and Word.  Too bad we bought the upgrade to work with Access 2003.

Thanks for your input.


Answer this question

VSTO & MS Access

  • markiv

    Here's the info on how VSTO 2005 is packaged:

    * VSTO 2005 (including the Access Developer Extensions) will be part and parcel of Visual Studio Team System.

    * VSTO 2005 (including the Access Developer Extensions) will all be included in the MSDN Professional and Premium subscriptions.

    * VSTO 2005 (including the Access Developer Extensions) will be released as a standalone product.

    I hope this helps!

    Thanks!
    Mike Hernandez
    Community Program Manager
    VSTO Team


  • Black Bits Neeraj

    I believe VSTO 2003 was a separate box. It was not part of the VS 2003 Professional. See the below link, Access Extensions are there
    http://msdn.microsoft.com/howtobuy/vsto/default.aspx


  • ToddKitta

    As an MSDN Subscription you are given access according to your subscription level, the VSTO 2 bits are available for download in the Subscription downloads.

    Regards

  • Developr

    VSTO 1 & 2 (2003 & 2005) doesn't allow you to work with MS-Access.

    IIRC, it will be possible, with VSTO 3, to develop Access Addin (Source: http://blogs.msdn.com/eric_carter/archive/2005/09/28/474958.aspx).

    But, for the moment, you will need to do some MS-Access automation if you want to work with it in your application.

    HTH.

    Bye.

  • Ranju_Akram

    Mike,
    Will be have to wait for VS2005 Pro media in order to get VSTO 2005, or will there a download I have downloaded VS2005 Pro, but have not found VSTO yet.

    Thanks.

  • Jonathan Barbara

    Yes, the Access deployment wizard is included in VSTO. I think it's on the Access Developer Extensions CD-ROM.

  • JimZim

    I just looked through the box of CD's that came with VS 2003 and there is no CD called "Access Developer's Extensions".  The only thing remotely close is the Office Tools CD which we have already looked over 100 times.  I bought the Professional Edition of VS 2003.  Am I missing a CD   Should the Access Developer Extensions be included

    Thanks Again

  • dick9

    We are currently developing Access 2000 databases.  That works fine because we have the Office 2000 Developer Edition.  We are now corporately upgrading to Office 2003 and that is where the problem is coming up.  How do we deploy our Access databases on Access 2003 machines   The short term solution has been to install Office 2003, but leave out Access 2003 and replace it with Access 2000.  Far from ideal if you ask me. 

    I guess now I have to go through the justification process with two options:

    1.  Ask for approx $250 CDN for the Access Developer Extension Addition to Visual Studio 2003.

    2.  Ask for $772 CDN to upgrade from VS2003 Pro to Visual Studio 2005 Tools for the Microsoft Office System.  We do not have an MSDN subscription so this seems like the best route.  It's too bad that the package Visual Studio 2005 Professional does not include the access developer extensions...seems a shame to give up 64 bit support to get the access developer tools since 64 bit is the future.  I'm based my information on http://msdn.microsoft.com/howtobuy/vs2005/editions/pro/Default.aspx

    Unfortunately for me, justifying another $772 for an upgrade just shortly after upgrading to VS2003 is going to be a tough sell.  Time to take off the engineer hat and put on the salesman hat.

    Thanks Again

  • lifeforms

    You need to be more precise. What doesn't work Do you get any error messages



  • saavyone

    Additionally you dont say what version of Access you are wishing to develop an application for, the Access Runtime License is built per version of Access and originally was included in the Office Developer Edition FYI

    Regards

  • vishu_gupta

    I should be more clear.  We are not even developing add-ins for Access.  I'd like to do the simple stuff.  Develop an Access database (currently just with VBA) and some 3rd party controls.  They run the package & deployment wizard (not sure what it's called now) and create a setup file.  Currently, we can't even do this with VS.net 2003 and Access 2003.  Am I missing something   This should be a very simple task.

    Thanks



  • WylieECoyote

    My problem is that the tools to deploy a MS Access database are not included in VSTO 2003.  How do I deploy a MS Access database   In office 2000 there used to be the package & deployment wizard.  Now there is nothing.  Reading the advertisements I thought this tool was included in VSTO 2003 but it does not look like it.



  • seeker55

    Thank you very much for the link.  That definitely proves that the Access Developer Tools are a separate product from VS2003 Pro.  Looking forward, will VS 2005 include VSTO(and Access Dev Tools) as part of the professional package or will it still be a separate item

    Thank you very much

  • VSTO & MS Access