Thanks Grasshopper. I have resolved that issue now but the problem now is that it gets near the end of the install, pauses, then 'rewinds' and uninstalls itself.

I'm really...

Thanks Kenneth, like you I did get the results to display but had problems saving the view so I added the tables manually, re-pasted the Sql code back in the...

Thanks gents. But where do I paste the code

"select DateT = DateAdd(hh,12, DateT)

select DateT = DateT + convert(datetime,convert(char(8),getdate(),112))"

In a Trigger for that particular table ?

Mitch........

Excellent, thats taken care of it.

Thanks again !!

Cheers. I've never used DatePart but I shall try this method now.

Thanks again.

Thanks Steve... i'll take a look at that.

Thanks AJ.

I have one other question, regarding a time field. I was using a time field as a datetime type but have now switched it to smalldatetime because i'd like...

Thanks Phil,

               yes, I created the table in Access and then upsized it.

The ID field is an autonumber field so I guess that is causing me the trouble.

Thanks...

Thanks Butch,

                  that worked great but how do I go about formatting the

value to a specific look, for example instead of the whole value showing date and time i'd...

Thanks Russel.

So what you advise is to create an account on the Webserver just to talk to the SQL server ? I have a SQL account that I tried...

Thanks Brian, that should keep me busy for a while....

Mitch........

Thanks guys... having looked the Auto close option is unchecked so...

Is there anything else I should look for ?

Mitch..........

Good question, I have no idea. Where would I look to find this out ? Is this a property I need to change/toggle for each DB in SQL Server ?...

Excellent, thanks Mike, thats put my mind at ease !! I'l ljust have to check to see whats wrong with the SQL server.