fbpx

SQL Server

SQL Server with Access Articles, tips and tricks

Avoid Number Conflicts with Microsoft 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!

2022-01-07T08:56:24-06:00August 23rd, 2016|

Insert CreatedBy and CreatedOn in Any Missing Data Tables in SQL

Insert CreatedBy and CreatedOn in Any Missing Data Tables in SQL 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 Automatica [...]

2021-06-11T07:38:18-05:00March 9th, 2016|

Use Microsoft SQL Server Native Client 11.0 for the Best Performance

Use Microsoft SQL Server Native Client 11.0 for the Best Performance [Update] There is a newer version of this post here. In our experience in using linked tables with Access, we get the best response using Native Client 11.0 with DSN-less tables. You could use ODBC 11 for SQL Server but then you wo [...]

2021-06-11T07:40:50-05:00August 23rd, 2015|

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

2022-01-07T08:50:41-06:00July 28th, 2015|

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

2021-06-11T07:45:45-05:00June 15th, 2015|

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

2021-06-11T07:55:32-05:00November 21st, 2014|

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

2022-07-26T03:27:30-05:00October 4th, 2014|

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

2022-07-26T03:26:58-05:00September 4th, 2014|

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

2014-09-02T21:30:40-05:00August 12th, 2014|

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

2018-10-28T13:45:40-05:00August 7th, 2014|
Go to Top