Have a look at http://msdn2.microsoft.com/en-us/library/bb188204.aspx 

"In SQL Server 2000, view results...

Do what it says - see http://support.microsoft.com/kb/919131 for more detail and links to the download for the DTS components.

Do it backward. You want the available / unused shades for a product. You have a form called e.g. fProductShades with a combo box called e.g. cbProductID which displays a product...

Google for redemption dll gets

http://www.dimastr.com/redemption/

free for non-commercial use.

Depends what you bookmark. I've got the MSDN site selected because that's got all the techy bits on it and that has it right up front.

If you go to SQL...

Lovely site.

One thing I would like is the ability to comment on scripts. There was a reasonably nice documentation script of the day posted recently but it fell down when...

Think about it, they don't just lose the postage they lose their (high) margin. So they lose twice.

The seller gains because (s)he gets nearer the "market" price. 

You, maybe,...

The other example of dynamic pricing is ice cream in movie houses. The point here is that it is fairly difficult to bring in your own ice cream so they...

The suitable machine need to be on all the time.  Yes, you can't avoid that one.

Linking to all your access databases. Suppose you have three databases d1, d2 and d3...

"Simplest" way is to use the windows scheduler on a suitable machine.

Second trick is to create a "master" database which links to all your Access databases which need importing.

Third...

Yes. This is based on the code in Chipman and Baron Microsoft Access Developer's Guide to SQL Server. (qv) I assume that all tables are owned by dbo and that...

See http://www.databasejournal.com/features/mssql/article.php/1459181

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=568

and then BoL on the procedures used.

To call the stored procedure from Access use an ADODB command object - see the help files.

One buglet, you need fairly...

Look at IS_MEMBER in BOL.

Simplest way is to create a stored procedure like

CREATE PROCEDURE Check

@Check bit OUTPUT

AS

SET @Check = IS_MEMBER('Marketing ')

GO

Then call it from Access and you know if the...

Two monitors is definitely the way to go. I just changed over about four months ago and it certainly has made a major difference.

 I do a lot of work in...

A bit of programming is (unfortunately) necessary. Neither runapp in a macro or shell in vba wait for things to finish.

However, those clever people over at the access web have got...