When creating computer applications we produce bugs. Errors are intrinsic to the human condition: we are not infallible. Either due to misunderstandings, ambiguous requirement specifications or lack of attention to detail, bugs will inevitably be found. When a bug is detected in an application durin [...]
Juan Soto will be presenting next week at the Chicago Access User Group (CAUG). This is a great opportunity to network with other software developers and Access users, as well as a perfect venue to share tips, techniques, and ideas. Join CAUG’s kick-off meeting with Juan Soto, Microsoft Access MVP, [...]
Omar Rodriguez is a Programmer at IT Impact, Inc. with over 16 years of experience and a proven track record in design, development, and implementation of complex projects and high-performance solutions. We hope you enjoy his first post on the Access Experts blog, and feel free to contact him here o [...]
We're happy to announce yet another event for all of you SQL Experts! On September 11th, Juan Soto, President of Access Experts, will be presenting to Chicago’s SQL Server User Group. Just one week away! Join fellow SQL experts for Juan Soto's presentation “Wish You Could Live the Glamorous Compute [...]
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 [...]
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 [...]
The time has come to create a platform that will allow Access users a way to meet virtually and discuss a wide range of topics. It is with great excitement that Ben and I introduce AccessUserGroups.org Why virtual access user groups make sense I've had the privilege to visit and present at Access us [...]
