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 S [...]
Lately I've been getting calls from people suffering from performance issues with SQL Server, in particular with the 2012 version. My first question these days is: "Which SQL Server client are you using?" A good Access developer would know the answer to that question, but if you don't, open control [...]
My dear readers, I've been asked by the Denver Area Access User Group to present on starting or improving your consulting practice: "Wish you could live the glamorous consulting life?" Here are the details, please register if you plan on attending! DENVER AREA ACCESS USERS GROUP Time: [...]
On May 10, I went to a SQL Saturday in Jacksonville, Florida. During that event I listened to a presentation by Andy Warren on "Building a Comprehensive Professional Development Plan." A Professional Development Plan (PDP), according to Andy Warren, is a written document that describes your short- t [...]
We use Windows Azure around here a lot, it works great with Access but it has one limitation: you can't copy data from one database to another since they don't support the USE statement. When there is a will, there is a way, and we've got a way you can copy data between Azure databases. Use Generate [...]
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 meet [...]
When you do Access development work as long as we have, you start seeing trends and understanding on how users react to your work. Over the years we've developed some great features that make using Access in a business setting ideal. Queues Businesses deal with services or orders that go through sta [...]
Cloud Data Security As a recognized leader in cloud enabling Microsoft Access, sometimes our firm comes across clients who are reluctant to place their data online, oftentimes due to the many stories they hear regarding data breaches or hackers obtaining data. Despite these common perceptions, cloud [...]
On May 13th, at 6:30 PM CST, I will be speaking about how you can easily create a solution that enable you to have your Access program working across broad geographic regions by leveraging SQL Azure Data Sync which is still in preview. In the talk, we will demonstrate how to get set up with replicat [...]
I am pleased to announce that AccessUserGroups.org have now developed further chapters, each of which have their own meetings online. The first one is today by Access Functions Group. The meeting will start at 7.00pm EDT, and will cover nulls, the Nz function, and two user-defined functions to easi [...]
A lot of times, I write a stored procedure to do several things. More often than not, I might be doing mass inserts, updates or deletions. Now, I'm not your average suspenders-and-belt guy. No, I go one step further and insist on wearing an overall over my suspenders and my belt, thank you very much [...]
