Go to Top

Blog

Using large parameters for 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 can get away with it using SQL Server Native Client. However, the new 13.1 ODBC driver comes with a number of features that won’t be available in the SQL Server Native …Read More

Tuesday April 11th: Learn how to spawn forms in memory, yes, you heard that right

Hi Everyone! This Tuesday I’m going to demo an amazing concept: How to spawn multiple copies of the same form in memory. Have you ever wanted to display multiple orders or invoices in your databases in separate forms using the same form design? One way of doing this would be to have multiple copies of the same form in your system, for example: frmOrder, frmOrder1, frmOrder2, etc. But the problem …Read More

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 is sure to position Access to compete with MongoDB or DocumentDB! Since it’s inception, Microsoft Access has been structured as a RDMS using a subset of …Read More

Exclusive! Join us March 14th our guest will be 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 answers to the pressing questions of our beloved Access program. Is Access going away? Is VBA going away? What computer language is Access built on? What new features has the Access team working …Read More

Access DevCon in Vienna Austria April 1st to 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 excited about the great lineup and chance to visit Vienna for the first time! For more information and to register, please visit http://www.donkarl.com/devcon/agenda.htm Let me know …Read More

Questions About SQL Server Security and Access Control You Were Too Shy to Ask

For many developers, database security and Access control is just something that gets in the way of development work. However, several recent security breaches have had devastating consequences and have caused a change in attitude about the value to any organisation of having database applications that meet industry standards for access control and security. The problem, however is in admitting that you have a problem and finding answers to those …Read More

If you could ask the 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 meet with the Microsoft Access team! What would you ask for? If you could ask one question of the Microsoft Access team, what would it be? What feature would …Read More

The Evolution and Future of Access

Mark your calendar for next Tuesday October 11th at 6.30pm central time! AccessUserGroups.org was founded by Access MVPs Juan Soto and Ben Clothier in order to foster virtual Access user groups nationwide.  This month the meeting of SQL Server with Access group will include an interview with Luke Chung from FMS Software.  Luke is a popular speaker at conferences in the US, Australia and Europe, and has published many articles in industry …Read More

Contact Us
  • This field is for validation purposes and should be left unchanged.