I must say, I am certainly detecting a change in direction from the Access team. It feels like Access is finally being recognized as being part of the office suite. We might not have many bullet points to show yet, but just the fact that we are there is a huge paradigm change compared to what we have seen over the last years when it comes to how Microsoft communicates about Access. And trust me, I know the Access Dev team is hard at work cooking up more stuff for us, though we are not yet at liberty to talk to you guys about it. I will say though that there is strong pressure from the whole MVP group towards the Access Dev team to be even more open and communicating about the work they do.
You can see the roadmap here, I’ve set the link to filter for Access only.
dBase File support
From what I’ve heard, you can’t have done much GeoSpatial work without coming across the dBase format. Now personally I’ve never done any of that kinda work, but I know that when the dBase support was deprecated from Access 2016 there were alot of people affected by this. This created the nr #1 Uservoice request in terms of votes. I will admit I personally have no plans of using dBase, but the TAKEAWAY from all of this is that uservoice is not in vain. The Access Dev team are actually listening, if you haven’t done so already, head over to Access.Uservoice.com now, and let the team know which features you care most about. Before posting a new request though, do take the time to see if someone else has already requested the same, and then add your votes to that item.
BigInt datatype Support
Another item from uservoice in progress!. As SQL server has evolved to support 64Bit architecture, it has also become increasingly common to run into BigInt as a primary key. Now if you link to that SQL server table from Access, it wouldn’t be recognized as a number but instead as a text string. So you could still work with it, but you might run into clumsy workarounds. Now they are working on natively supporting it! I mean one of the great powers of Access has always been the ability to connect to all databases, even those that are outside of our control. Now the Access team is showing a commitment to maintain, and evolve that capability!
Do you wish to stay up-to-date with what is happening in the Access world? Then don’t forget to subscribe, and I will do what I can to keep the information flowing!