none
Access going away?

    Question

  • We have a consultant (MWH) who is telling our managers that Microsoft will no longer be supporting Access and we therefore need to replace all of our in-house applications with COTS. They don't differentiate between backend (Jet) and frontend, they just make this blanket statement.

    As far as I can discern, there is some talk of phasing out Jet but I can't find any reference to Access as a front end going away at all. Can you give me some sort of "official" word from Microsoft on this issue?

    Since I think Access is the most fantastic program ever created, my opinion doesn't cary much weight.

    Wednesday, June 01, 2011 2:33 PM

Answers

All replies

  • It's better to find a new consultant. Frankly, it is his duty to provide facts about his statement but not yours to find out that he is not right. And I bet he won't find anything related to his words.
    Andrey V Artemyev | Saint-Petersburg, Russia
    Wednesday, June 01, 2011 2:38 PM
  • hi,

    Access is still an active product of Microsoft. The point about Jet is correct. Since Access 2007 the database engine is called ACE, which is a different product then Jet.

    In other words: Your consultant is wrong about Access.


    Microsoft MVP Office Access
    https://mvp.support.microsoft.com/profile/Stefan.Hoffmann
    Wednesday, June 01, 2011 2:41 PM
  • Bradford Burke wrote:

    We have a consultant (MWH) who is telling our managers that Microsoft
    will no longer be supporting Access and we therefore need to replace all
    of our in-house applications with COTS. They don't differentiate between
    backend (Jet) and frontend, they just make this blanket statement.

    Either your consultant doesn't know what he's talking about or he
    deliberately provides wrong information, reason enough to find a better
    consultant. ;-)

    With Office 2007 Jet has been replaced by ACE (Access Data Engine), the
    successor of Jet. It covers full Jet functionality plus new field types
    (MVF, Attachments, ...). For more details see
    http://office.microsoft.com/en-us/access/


    Peter Doering [MVP Access]

    Wednesday, June 01, 2011 2:59 PM
  • What everybofy else said.

    Beside, if that were the case, why would MS have a large team working on the next version, not to mention the humongous effort that was invested in all the new features that were added in 2007 and 2010.

    Wednesday, June 01, 2011 3:44 PM
  • I agree with Marshall and only this one quote can be a good argument for you, Bradford,

     

    Thanks to all of you who stopped by to give us feedback about Access and Access Services 2010 and ideas for the future version of Access. We are glad to see that many of the comments are already being addressed as part of our planning for the future version of Access and Access Services. Keep this feedback coming!

    Lois Wang from the Access team.

     

    http://blogs.office.com/b/microsoft-access/archive/2011/05/26/access-services-and-it-pros-impressions-from-teched-2011.aspx


    Andrey V Artemyev | Saint-Petersburg, Russia
    Wednesday, June 01, 2011 3:59 PM
  • Hello:

    I am a full-time Access and Excel consultant, and I can personally tell you that many of my major clients rely heavily on Access for data analysis.  These large corporations may have ERP solutions as large as Oracle Applications 11i, but in the end, Access is indispensable as a quick method of data analysis.  My smaller clients use it as the "least cost" and fastest way to provide an application.

    So, ignore the bad advice.

    Regards,


    Rich Locus Logicwurks, LLC www.logicwurks.com
    Wednesday, June 01, 2011 6:33 PM
  • I'll chime in as well. 
     
    This myth that Access is "going away" has been around forever, and it
    is a favorite refrain of the biased and/or uninformed.  Each version
    of Access has had huge amounts of effort put into it by the team at
    Microsoft, many of whom I know personally, so I know they really
    exist.  :)  Each version has many new features, and the team is
    currently hard at work on the next version.  Access is an active,
    viable product with a bright future and which supports millions of
    working applications.
     
    So, I would echo others' responses suggesting that you find a
    consultant that doesn't make incorrect blanket statements.
     
    Cheers,
     
    Armen Stein
    Microsoft Access MVP
    www.JStreetTech.com
     
     
    Wednesday, June 01, 2011 11:12 PM
  • Bradford Burke wrote:

    We have a consultant (MWH) who is telling our managers that Microsoft will no longer be supporting Access and we therefore need to replace all of our in-house applications with COTS. They don't differentiate between backend (Jet) and frontend, they just make this blanket statement.

    As far as I can discern, there is some talk of phasing out Jet but I can't find any reference to Access as a front end going away at all. Can you give me some sort of "official" word from Microsoft on this issue?

    How many times have we heard this over the past fifteen years?
    Rhetorical question of course.    As others have stated Access is a
    product that is being heavily worked on by a large team in Microsoft. 
    Tony


    Tony Toews, Microsoft Access MVP
    Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
    For a convenient utility to keep your users FEs and other files   updated see http://www.autofeupdater.com/

    Saturday, June 04, 2011 12:19 PM
  • Tony Toews - Access MVP <tony@granite.ab.ca> wrote:

    How many times have we heard this over the past fifteen years?
    Rhetorical question of course.    As others have stated Access is a
    product that is being heavily worked on by a large team in Microsoft. 

    Here's a link proving a new version is being worked on.
    http://blogs.office.com/b/microsoft-access/archive/2011/01/05/access-15-developer-kitchen-call-for-participation.aspx

    Tony


    Tony Toews, Microsoft Access MVP
    Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
    For a convenient utility to keep your users FEs and other files   updated see http://www.autofeupdater.com/

    Saturday, June 04, 2011 12:26 PM
  • ******

    YES, your consultant knows EXACTLY the right answer.

    Jet ***, it doesn't work RELIABLY for multiple users.

    Go ask a bunch of SQL Server people if they should throw away Jet. 99.999 % of SQL Server people would fully agree that Jet is a waste of time.


    • Edited by Bruce Song Monday, June 06, 2011 10:38 AM clear inappropriate words
    Saturday, June 04, 2011 2:44 PM
  • the new version is going to be called LIGHTSWITCH and yes, your consultant is CORRECT, it does not support JET.
    Saturday, June 04, 2011 2:45 PM
  • Access is not going anywhere.

    This is a mere salemans scare tactic!


    Daniel Pineault, 2010 Microsoft MVP
    http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net
    Saturday, June 04, 2011 6:24 PM
  • Aaron, Long Time, No Have to See You.

    Your years-long campaign to trash Access has never gone anywhere, and it will only lead to further public humiliation for you to continue it.

    Please, do yourself a favor by sticking to topics where you can offer useful advice.

    Life is too short to waste it on petty vendettas. Give yourself a break and start looking on the bright side. You'll be a happier person in the long run.

     


    With Joy Wend Your Way
    Saturday, June 04, 2011 8:45 PM
  • Oh, my. Partial truths are worse, in some ways, than flat out falsehoods.

    1) Lightswitch is going to support Access as any one can tell by visiting their web http://www.microsoft.com/visualstudio/en-us/lightswitch Note that this won't be available until post-beta, according the page, and that it doesn't mention either JET or ACE specifically. I guess, if you want to say that Lightswitch is not going to support JET, that could be true. It's also irrelevant. I would be surprised, in fact, if there were any plans to support JET since the new Access engine is ACE. This is not an area where one would expect backwards compatibility. What I have read is that MS itself won't offer that support, but that it will be available through third-party vendors who wish to develop the appropriate providers.

    2) New version of "what"? You "conveniently" left that out, didn't you? I am guessing that your intent in omitting that detail was to imply a falsehood, which reflects very badly on you. The new version of Access will be Access. The new version of Lightswitch will be, erm, Lightswitch. Implying otherwise seems not to be an honest tactic.

    I refer anyone who wants to know the truth to visit the Lightswitch pages and read what MICROSOFT says about it.

    Often, attempts to do harm through innuendo and half-truth end up harming the perpetrator more than the intended victim. Again, Aaron, I urge you to get over whatever has been bugging you and look for ways to contribute positively. It might help make you a bit happier.

     

     

     

     


    With Joy Wend Your Way

    Sunday, June 05, 2011 12:15 AM
  • Hi Bradford,

    We'd better get the newly information from the Access official blog and we can also ask the question on it:

    Access blog information:

    http://blogs.office.com/b/microsoft-access/

    Give us feedback – How can we help you work faster and more efficient?

    http://blogs.office.com/b/microsoft-access/archive/2010/03/12/give-us-feedback-how-can-we-help-you-work-faster-and-more-efficient.aspx

    Because the forum is for Access development problems, you'd better post your question on this forum:

    http://answers.microsoft.com/en-us/office/forum/office_2010-access?page=1

    In my opinion, Access will not be discarded by Microsoft, a lot of people are using it in the worldwide and it will be continuously improved and supported by Microsoft. 

    Finally, thank very much for all members' active participation about this topic.

    Best Regards,


    Bruce Song [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Bruce Song Wednesday, June 15, 2011 12:57 PM
    Monday, June 06, 2011 11:09 AM
  • I teach Office. Once of my students told me that he went to BestBuys to purchase Office. He said the salesman told him that Access was going away. I Googled it and I found this question. Is there any official comment on this.

    Thursday, June 09, 2011 5:26 PM
  • You might do well NOT to put much faith in anything  a Salesperson in an Office Supply store says. There ARE more reliable sources, such as the MS Blog linked above in Tony Toewes post. Go read about how MS is calling for input on their development plans for the next version.

     

     

     


    With Joy Wend Your Way
    Thursday, June 09, 2011 7:50 PM
  • dijait wrote:

    I teach Office. Once of my students told me that he went to BestBuys to purchase Office. He said the salesman told him that Access was going away. I Googled it and I found this question. Is there any official comment on this.

    Read our responses.  There are ten useful responses other than Aaron
    Kempf's response.  Some with links to Microsoft Access product group
    blogs.

    BTW since when does anyone believe what a sales person states?
    Especially one who works in retail.

    Tony


    Tony Toews, Microsoft Access MVP
    Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
    For a convenient utility to keep your users FEs and other files   updated see http://www.autofeupdater.com/

    Thursday, June 09, 2011 8:36 PM
  • dijait,

    Good point to raise this misunderstood concept of MS Office range of products. The main reason is that when somebody sees MS Office is without Access, he/she is assuming that Access is no longer being supported.

    There companies that do not use Access, purchase MS Office with Access without knowing that there is a cheaper version that comes without Access.

    I hope that Microsoft could educate retailers salesman in shops about the different version and packages of MS Office.

    Friday, June 10, 2011 2:35 AM