During the time period check the following

-Can you connect to SQL Server on the server using management studio

-can you connect using management studio or with an ODBC from a workstation

-Also...

Nice post, I'm working on this now.

sorry guys dumb error it needed to be

Select amount

from Sheet_Entry

where [sheet_entry_KEY] = '2569'

silly brackets

thanks for your help I'm sure it should work now I just need to get to the...

Here is the table scripted, the only column I need is sheet_entry_KEY which I am joining on and amount.

/****** Object: Table [dbo].[Sheet_Entry] Script Date: 01/09/2009 04:54:14...

wow fast responses thanks, those examples are perfect.. is there any reson I would have a problem calling a KEY? for example I can select staff_id fine but...