Using Large Parameters for Microsoft SQL stored Procedure with DAO As many of you already know, SQL Server team has announced deprecation of OLEDB for SQL Server database engine (Read: we can't use ADO because ADO uses OLEDB). Additionally, SQL Azure does not officially support ADO, though one still [...]
MayBeSQL Coming to Microsoft Access! In a stunning development, Microsoft Access will debut a new version of SQL called MayBeSQL, in response to the market clamoring for more NoSQL solutions. Originally, NoSQL meant "No SQL" but in more recent iterations, has come to mean "Not Only SQL". The change [...]
Exclusive! Join us With Our Guest Michal Bar, Access Program Manager Exclusive! Join us on Tuesday March 14th at 6.30pm CST with our guest Michal Bar, Microsoft Access Program Manager at Microsoft! Learn about the future of Access, see demos on new features the Access team has worked on and get answ [...]
Microsoft Access DevCon in Vienna Austria April 1st - 2nd, 2017 This year Access MVP Karl Donaubauer has invited me to speak at his first Access DevCon in Vienna on April 1st and 2nd 2017. Karl has many years of producing similar events in German but this time around it's in English and I'm really e [...]
Ten Ways Your Data Project is Going to Fail Data science continues to generate excitement and yet real-world results can often disappoint business stakeholders. How can we mitigate risk and ensure results match expectations? For more information go here. [...]
If you Could Ask the MS Access Team Any Question, What Would it Be? Next month Ben and I are once again traveling to the MVP Summit at Microsoft headquarters for our annual pilgrimage to the mothership. It's a wonderful affair were we get wined and dined and fawned over by Microsoft, and of course m [...]
dBase Support is Back in Microsoft Access! After an overwhelming outcry from the user community, Microsoft has again added support for dBase import into Access! The feature will only be for Office365 users but they plan on rolling it out to everyone eventually. Check out the official announcement he [...]
Use Microsoft SQL Server Native Client 11.0 for the Best Performance [Update] There is a newer version of this post here. In our experience in using linked tables with Access, we get the best response using Native Client 11.0 with DSN-less tables. You could use ODBC 11 for SQL Server but then you wo [...]
Effective Communication Using FogBugz Effective communication between team members is of utmost importance when it comes to achieving quality software; however, the quality of the software is almost never perfect. For this reason, it is common for clients to report errors in applications to its supp [...]
Creating Custom Microsoft Access Formulas and Using Them Effectively MS Access has a very powerful support for using expressions in your forms/reports’ controls. For example, showing a sum of some column can be as simple as putting down: =Sum([SomeColumn]) and we’re done! Now, sometimes, we don’t ha [...]
9 Microsoft Access Developer Interview Questions A few weeks back, I created a post called 9 Interview questions to ask Microsoft Access Developers, and I challenged my loyal readers to try and answer them. Below are the questions and answers. 1. What is a collection? Answer: A group of objects held [...]
