Go to Top
  • No products in the cart.

Blog

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

dBase support is back in 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 here: Back by popular demand—dBASE file support in Access Join us next Tuesday for a great talk on SQL Sequences and how to use them in Access! The Access …Read More

Find all queries that use a particular table

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