Exclusive! Join us With Our Guest Michal Bar, Access Program Manager

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

Juan Soto2025-05-24T19:02:45-05:00March 12th, 2017|

Microsoft Access DevCon in Vienna Austria April 1st – 2nd, 2017

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

Juan Soto2021-11-23T07:32:19-06:00February 22nd, 2017|

Unanswered Questions About MS SQL Server Security and Access Control

Unanswered Questions About MS SQL Server Security and Access Control 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 [...]

Susan Pyne2021-06-11T07:32:51-05:00November 15th, 2016|

Ten Ways Your Data Project is Going to Fail

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

Susan Pyne2021-06-11T07:33:41-05:00November 15th, 2016|

If you Could Ask the MS Access Team Any Question, What Would it Be?

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

Juan Soto2021-06-11T07:34:25-05:00October 21st, 2016|

The Evolution and Future of Microsoft Access

The Evolution and Future of Microsoft 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 [...]

Susan Pyne2021-06-11T07:35:14-05:00October 4th, 2016|

dBase Support is Back in Microsoft Access!

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

Juan Soto2021-06-11T07:36:03-05:00September 8th, 2016|

Avoid Number Conflicts with Microsoft SQL Sequences

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!

Robert Aaron2022-10-26T17:17:00-05:00August 23rd, 2016|

Find All Queries That Use a Particular Table

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 inste [...]

Juan Soto2022-01-07T08:54:50-06:00June 6th, 2016|

Insert CreatedBy and CreatedOn in Any Missing Data Tables in SQL

Insert CreatedBy and CreatedOn in Any Missing Data Tables in SQL 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 Automatica [...]

Juan Soto2021-06-11T07:38:18-05:00March 9th, 2016|

Count All the Objects in Your Database

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

Juan Soto2021-06-11T07:39:16-05:00February 19th, 2016|

Blog