Avatar of Derek Brown
Derek BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on 

Access limited life?

A friend of a friend (always dangerous) suggested that Access may be dropped at some point in the next Microsoft version.

Does anyone know anything about it or if there is any truth in this
Microsoft Access

Avatar of undefined
Last Comment
PatHartman
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Always rumors and Microsoft is investing a lot of energy into Power Apps, BUT, they are also putting resources into Access.   They have added several new features in recent versions, and if it was truly going to die, I highly doubt they'd be doing that.

 Also Access based apps have a large installed base.   If they killed it off now, with nothing to offer as a replacement they would loose a considerable amount of business.

 So any statements about the death of Access are probably very premature.

Jim.
SOLUTION
Avatar of Thierry van Mourik
Thierry van Mourik
Flag of Netherlands image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Microsoft has being trying to kill Access for ages but i don't see much success on this...the tremendous user base along with the fact that is by far the best RAD tool makes it almost impossible to kill...
<<Microsoft has being trying to kill Access for ages >>

 That's not true per say.   Microsoft has no interest in killing off Access, but they are focused on moving to a web/mobile world.   So any desktop orientated product is fair game.

Jim.
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

You should be more careful when selecting friends.

/gustav
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

@Jim considering the fact that Access haven't really received any real update  especially in the code area based of another "killed" beloved product (VB6) i think that my statement carries some truth...we talk that the code is same from 20 years ago from the era of Access 97...not to mention the LightSwitch
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
@John,

<<@Jim considering the fact that Access haven't really received any real update  especially in the code area based of another "killed" beloved product (VB6)>>

  Ah but it has.  In regards to VBA, you did get 64 bit and a brand new version of VBA, which was VBA7 with Access 2010.   Access has also gotten several features that I think prove that Microsoft has no intention of killing it off, such as the recent support for BigInit, and additional data connectors for things like oData and Sales Force.

 If they were going to let it die anytime soon, there would have been no need for either or the time and money spent on them.

<<i think that my statement carries some truth...we talk that the code is same from 20 years ago from the era of Access 97...not to mention the LightSwitch>>

  And all I'd call that is great backwards compatibility.

  In regards to LightSwitch, as I said, Desktop products since 2007 or so have been fair game.   But LightSwitch was never very well defined in it's role, did not have an installed user base, etc, so it was very easy to kill off.   With Access, not so much.

  Personally I think Access in it's current desktop form will be with us for quite some time to come....at least 10 years if not longer.  

  No matter what Microsoft seems to think, to your point the desktop is far from dead.

Jim.
SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of PatHartman
PatHartman
Flag of United States of America image

The reports of the demise of Access from around 2000 stem directly from the SQL Server group who built the SQL server desktop engine that shipped with Access at that time.  Since the idea was to switch from "Jet" which everyone who didn't know any better referred to as Access to the new SQL Server option, they said "Access" was dead when what they really meant was Jet.

The reports of the demise of Access from around 2005 again stem directly from the SQL Server group who were responsible for Jet (which still hadn't died by the way).  With the release of A2007, Access substituted ACE (which was controlled and developed by the Access team rather than the SQL Server team)  for Jet so technically the SQL Server people were right.  "Access(Jet)" is dead.  Long live "Access(ACE)".

The more recent rumors stem from the fact that Microsoft decided to not continue support for Access web apps that were integrated with SharePoint.  The AWA never got any momentum for four reasons.
1. They didn't support any coding language.  Everything was done with macros so what you could do was pretty limited.
2. There was no conversion path from a desktop app to an AWA so converting was a complete rewrite and not trivial because of the huge differences between VBA and macros.  Being able to port the data was simply insufficient since that has always been fairly easy to do.
3. They were totally dependent on SharePoint and people were simply not interested into being forced to support SharePoint just to use AWA.
4. Many Access apps integrate with Word and Excel and Outlook and without a programming language, that integration would be lost.

Jet is still alive and well but now Access is tied to ACE.   Doesn't matter though.  Everyone who doesn't know any better still refers to Jet/ACE as Access and all the bad press you ever see about Access is actually targeted at the two desktop engines who people cannot in their minds separate from Access which is a Rapid Application Development tool.  Access is the front end application.  Jet and ACE are desktop database engines and also serve as the repository for Access objects and that is why Access cannot seem to be separated from them in the minds of way too many.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo