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,876 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,081 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,977 reads


Getting Started on AWS RDS


I’m expanding my skill set into AWS in a big way. So, one of...

Daily Coping 1 Jun 2020


I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Setting Up GitHub Desktop (formerly GitHub for Windows)


When I started using Git, I first download GitHub for Windows. I went searching,...

Read the latest Blogs


Assignment Help

By dilipjadhav

I was wondering if anyone would be kind enough to help me with a...

Accuranker Keywords Ranking Tracker

By alexrory4650

Accuranker Keywords Ranking Tracker is a catchphrase rank tracker apparatus that values incredible exactness...

Best Tools For Marketing Of Your Content

By alexrory4650

While no content marketing tool can supplant a strong system and skilled people, having...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers