Linking Access to SQL Server

  • Article

For quick and dirty work, sometimes Access is the best way to work with SQL Server. Andy Warren brings a basic tutorial on how you can link Access to your SQL Server tables to easily and quickly manipulate data.

3.44 (18)

2007-11-02 (first published: )

26,892 reads

Digging Into Access Performance

  • Article

Access can be a very quick and easy to use tool for working with SQL Server data and for quick and dirty projects, it might be the best tool. But there can be performance issues at times and Andy Warren digs into some of these based on some analysis of what Access does behind the scenes.

4 (2)


8,095 reads

Consume Web Service from Access

  • Article

A few months ago, I posted an article here at DBJ named How to Pass Access Data Across the Web. One reader expressed concern over using the Microsoft Internet Explorer library because of security issues. While I do not share his fear, I appreciate that others might, so I began to think about how the process could be enhanced by substituting a Web Service for the traditional ASP/Querystring web page approach described in the article. What follows is the fruit of those labors.


2,821 reads

Access to SQL Server: Getting Started with Access Projects

  • Article

SQL Server 2000 and Access databases are two technologies closely linked with the new Access ADP format using SQL Server as the basis for the code. Access Projects are also a way to closely link the two products together and take advantage of each to produce an application very easily. Author Kathi Kellenberger brings us part 3 of her Access series with a look at Access Projects.

5 (1)


9,980 reads


2020 Advent of Code–Day 1


This series looks at the Advent of Code challenges. I started the Advent of...

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)


Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...

One Chart at A Time Video Series


Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...

Read the latest Blogs


Interesting bug in SQL 2016 CHOOSE

By ScottPletcher

While trying, in SQL 2016 (13.0.5850.14), to see if CHOOSE allowed an inline query...

SSIS jobs

By sqlguru

I have always run the SSIS package using SQL Agent jobs. However, I am...

String Shrinking

By Steve Jones - SSC Editor

Comments posted to this topic are about the item String Shrinking

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers