I think SQL 2000 was such a hot seller Microsoft did not want to rock the boat.  But 5 years was just a little too long. 

My vote 3-4 years...

Yes very very bad, really a NO DESIGN table.  Believe or not, I had to deal with NO UNIQUE CONSTRAINT Tables, these BAD Designs with Commercial Enterprise systems.

This does the same thing, simplier and NO CURSORS.  If it can be done without a cursor, than much better. 

CREATE TABLE [dbo].[Employee] (

            [id] [int] NULL ,

            [name] [Varchar] (50)...

I have been doing this for years, it is the greatest quikie adhoc reporting tool.  Worth repeating...

Left out a step though , To always make sure you get lengthy column results:

Set...

If you are doing this in Query Analyzer, make sure your settings are correct for output.   Oh, Like Ray has pointed out already and of course Query--> results in text

Relink your table to SQL, delete link then link again, the column schema could of been changed in SQL or corrupted in Access.

This may happen if any changes, even minor,...

Yes, it is a bad idea.  But don't say it is, don't worry and let the game be played.  Like most of the responses here, it will naturally change back to...

Here is a adhoc Code Generator for Basic Crosstab functionality.

Of course SQL 2005 will now have the PIVOT statement to make this easier!

   /***  Template to CODE Generator to Create...

Yes, good article, Connection strings well written saves lots of time when maintaining an Application.

This is very good. I have used this method in the past when we had to...

This will give your desired reults without error.

Declare @Res int ,@denominator int

Set @Res = 0

Set @denominator = 0-0

Select @Res = CASE WHEN @denominator...

If you are getting null then the Application Name Property in the Connection is not set.

Add the Application Name Value to your  SqlConnection connection string

application name="Northwind_Test-1.1"

This can be added in...