Go to Top

Blog Archives

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

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

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. 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

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

Insert CreatedBy and CreatedOn in any missing tables

When we design Access with SQL Server solutions we almost always add CreatedBy and CreatedOn to all of our tables, allowing our clients to see who created records in the Access frontend. Script to add CreatedBy and CreatedOn Automatically to tables Many times we inherit SQL databases and we need a quick way to add both fields to all tables in the database. To that end we use the following …Read More

Count all the objects in your database

The other day our company was tasked to convert a lot of Access databases to multiple SQL Server backends. To get a sense for the tasks involved, we needed a way to count all the tables, queries, forms and macros in each database. I did a quick Internet search but did not like any of the code snippets, so I created my own little program that will print out the …Read More

Contact Us