Go to Top

Blog Archives

Text or Numeric Field – A simple method to switch data type.

I recently worked on a project where our client is selling a product throughout the USA built on Access with SQL Server, it works by importing data into SQL and then analyzing it with Access reports. Unfortunately each customer may have a primary key format as a long integer and others where it’s a string, (combination of numbers and strings), we quickly discovered it caused problems with reports not sorting …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

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

In depth discussion of the SQL Server Migration Assistant

AccessUserGroups.org TUESDAY, MARCH 10th @ 6.30pm CDT This month Juan Soto, Microsoft Access MVP,  will be presenting at talking about how to install SSMA, configure it’s use, doing your first upload to SQL Server and how to leverage SSMA in subsequent migrations. This is a must attend for anyone looking to migrate a solution to SQL Server. Interested in joining one of our virtual AUGs? We have groups across the globe in …Read More

Access User Group Webinars for December

Here are the details for 2 of our 5  Access User Group (AUG) meetings this month. This is a wonderful opportunity open to novice and professional developers to learn new tricks. Each webinar is free and you don’t have to be a member to participate. Interested in joining one of our virtual AUGs? We have groups across the globe in various languages. Sign up with free membership and receive email …Read More

Tuesday, October 14th @ 6.30pm CDT – Working with XML Data Efficiently

Ben Clothier, Access MVP and co-founder of the AccessUserGroups.org, will be presenting at this month’s meeting for the SQL Server with Access Group. He will discuss working with XML data with an SQL Server backend. Earlier this year Ben posted a 2 part blog posts on this topic and this will be an update/improved version of these resources.  Here are the links: Part 1 & Part 2 In the talk we will cover: How to use …Read More

SQL Server with Access Meeting

Please join Ben Clothier on Tuesday August 12th at 6.30pm CDT for our monthly meeting. We are excited to have monthly meetings to discuss Access with SQL Server topics! We meet every second Tuesday of the month at 6:30 PM Central Daylight Time (CDT). Topic: Managing large files with Access and SQL Server This meeting will be presented by Ben Clothier. This is a follow-up on Adolfo’s excellent presentation where he mentioned …Read More

Access User Groups

The purpose of this group is to create virtual chapters throughout the world, from beginning user groups to advanced topics such as SQL Server. Chapters can be organized around a language, such as Spanish, a region, such as Spain or a topic of interest, such as Access functions. We hold monthly meetings using https://join.me/accessusergroups where you can join the discussion or just listen in and learn more about the topic discussed. Here is a list …Read More

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