fbpx

SQL Server with Access Articles, tips and tricks

7 Ways To Do Sequential Numbering in Microsoft Access

7 Ways To Do Sequential Numbering in Microsoft 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 oth [...]

7 Ways To Do Sequential Numbering in Microsoft Access2021-06-11T07:44:23-05:00

Create Delete and Update Audit Tables in Microsoft SQL Server

Create Delete and Update Audit Tables in Microsoft 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 purpos [...]

Create Delete and Update Audit Tables in Microsoft SQL Server2021-06-11T07:45:45-05:00

SQL Server Update Breaks Microsoft Access Application

SQL Server Update Breaks Microsoft 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 s [...]

SQL Server Update Breaks Microsoft Access Application2021-06-11T07:55:32-05:00

Tuesday, October 14th – Working with XML Data Efficiently

Tuesday, October 14th – 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 post [...]

Tuesday, October 14th – Working with XML Data Efficiently2021-06-11T07:57:49-05:00

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

Be an SQL Server Consultant from Home – Chicago Event2014-09-08T19:41:14-05:00

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

SQL Server with Access Meeting2014-09-02T21:30:40-05:00

Are you having performance issues with SQL Server?

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

Are you having performance issues with SQL Server?2018-10-28T13:45:40-05:00

Copy Data Between Two Azure Databases

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

Copy Data Between Two Azure Databases2021-06-10T10:04:33-05:00

Replicating made simple: SQL Azure Data Sync

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

Replicating made simple: SQL Azure Data Sync2014-05-12T00:07:46-05:00

Running Transactions in a Stored Procedure

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

Running Transactions in a Stored Procedure2015-09-11T23:05:09-05:00

Working with XML Data Efficiently – Part Two

This is part two of our two-part series on working with XML data with a SQL Server backend. Part one can be found here. In part one, we showed how much simpler and effective it was to manipulate XML data by doing it directly in the SQL Server layer as opposed to front-end or middle-layer code. The i [...]

Working with XML Data Efficiently – Part Two2016-04-02T00:00:23-05:00
Go to Top