Sorry,

The problem is the GROUP BY clause like this :

select count(*) from EmptyTable1

group by AnyTableOneField

it returns me nothing but an empty recordset.

Is there a way to correct this...

If you want to save/load your image in/from your SQL Server Database you will need to use the Stream object of ADO.

Dim strStream As ADODB.Stream

Dim rs As ADODB.RecordSet

Dim cn...

This view link 15 tables. It is BIG. All the table are named explicitly but one of them is like "Table.*" because its the principal table of this view.

Any ideas...

Yes I remove a column from my table. Since sp_refreshview is working when I Add a column I wonder why there is nothing to refresh a view when I remove...

I don't want to alter my view because it is very big and I need to run all my SQL script at my customer office so I want my SQL...

I used sp_refreshview to refresh my view.

sp_recompile only recompile Tables and Views when a stored procedure who reference them is run.

Thanks a lot,

DaSaint

webmaster@obscuresun.com

Antares686,

Sorry I just tried it and it doesn't worked. I had a field to my table. I run a select on the view that return the fields of this table...