I also RTRIM(LTRIM()) to two of the columns, then did UPDATE STATS and UPDATEUSAGE and the size didn't change.

This doesn't make any sense to me. I have converted columns...

I have created a new table with only VARCHARs and have loaded it. The size didn't change.

I have tried it with and without NULLs. Same results....

I was just giving you a little crap about Access. If I could offer any insight into your problem (besides using Access) I would. I have not yet...

So I guess that I'd have to create a new table with all VARCHAR and copy all rows from the old table to it?

Completely agree with on the normalization thing. That was my first thing I wanted to try. I don't have control over that though.

I can change the...

One trick that I use it to copy the query twice into a single query window.

The top one will stay the same. Make your changes to the bottom one....

Hey William.

If you have Office 2007 installed, then you don't need Sql Server 2000. You should have Access 2007 installed, so that should meet all of your database needs,...

My server is stand-alone - nonclustered. SP4 was installed a long time ago and ODBC has been working fine before and after the install.

I set the Client...

I can't find anything wrong with my machine. Everywhere I looked pointed to a problem with the firewall or a network problem. Since the reboot fixed everything and...

I looked on my 7 and 2000 machines and I can't find ODBCping anywhere. I looked on my client installs also, nothing. I did some short research and...

Thanks for the reply. Just trying to make sure I wasn't missing anything obvious. I didn't want to be quick to blame someone else.

That's what my opinion is also, but I need to be able to say that it wasn't anything wrong with my server.

"As I said originally hard drives were failing." - that was suppose to read:

"As I said originally hard drives NOT were failing." - I forgot about that correction.

No problem. ...

My problem didn't have anything to do with a hard drive going bad. I should have made it clear that the cache was on the PERC 3 card, not...

Oh yea, I have a pic of him in my side profile.

<-- right there!!