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
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.
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
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
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 here. Join us next Tuesday for a great talk on SQL Sequences and how to use them in Access! The Access with SQL Server group is back from vacation …Read More
Note: I’ll be presenting on this topic at the Access with SQL Server group online. Please join me on September 13th at 6:30 PM CST, join the group to get an email with all of the meeting details, it’s free!Read More
We just completed a massive 39 database conversion to SQL Server for a client in Tennessee which was quite challenging, we had to not only upsize all the tables, but switch the system from importing/exporting between databases to using linked tables instead. At times we needed to find which queries was using a table, so we used the following code to quickly find a table in all of the queries: …Read More