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
SQL Server with Access Articles, tips and tricks
Avoid number conflicts with 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!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
Ways To Do Sequential Numbering in Access
Occasionally we come across project requirements that include the ability to do sequential numbering in Access on a set of data. We cannot just use the auto-number data type because there is no promise of sequentiality but only uniqueness. In other words, if someone creates a record then later deletes it, there will be a gap in the sequence. So, what are our options? There are actually several ways, each …Read More
Create Delete and Update Audit Tables in SQL Server
This is a modification to an earlier tip I wrote, whereas this code will only record delete changes, my earlier article will record delete and update changes to the data. I found code online by Brett Kaiser and I modified it for my purposes, with a mind to other Access developers I made some changes which I will explain here. Note: This article assumes you’re familiar with SQL Server tools …Read More
SQL Server update breaks Access application
UPDATE 12/3/14: Please visit Darren’s blog for the latest on this issue, than come back here to see some solutions to this problem. You can visit Darren’s blog here. My inbox has been flooded by reports around the world of Access suddenly being slow or unusable after the latest set of patches issued by Microsoft. Turns out one of the patches for SQL Server will in effect render Access applications using …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
Be an SQL Server Consultant from Home – Chicago Event
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 Computer Consulting Life?” to find out how you can become a successful consultant from your own home. This is a perfect …Read More