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,869 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,078 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 with SQL Prompt 10


This week we released SQL Prompt 10, which is an exciting milestone for us....

Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting


Check out this new series that I’ve started on Power Platform Quick Tips. This...

The curious case of CHAR(0)


Over the years I’ve seen quite a few strange things with SQL Server. This...

Read the latest Blogs


Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

I am new to SQL world

By Kabina

I eager to learn sql , I am currently working on Access . I...

Learn from the Troubles of Others

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Learn from the Troubles of...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Leaving SQLCMD

See possible answers