waht you mean 4 part table instead of openquery ???

the reason I'm using char(8000) is I spent the last 3 days trying to figure out and If I change back

to...

I did, I add single quotes around the date field and the same error appears.

Insert

into openquery

(

LPUSA01,

and the original table is on AS400, I create that view using the OPENQUERY script, and I cannot change nothing on AS400

that view provide details of the invoices, but the invoice table doesn't have a primary key, the application do not accept it, I try to modify and I shut down...

I need a primary key on that view and the 2 tables involved there is no primary key, and I don't know how to do that.

this statement is from a view

Well, I fix the problem temporarilly executing the NET USE command and map the drive and then executeint xp_cmdshell and after that NET USE again and Unmap the drive, works...

Yes the server and the user has permission to delete the file

I did re-initialize all and nothing same error:

and

I don't have that store procedure sp_browsereplcmds

thanks

I did and nothing happen:

DROP TABLE [New Table]

GO

CREATE TABLE [New Table] (

[STD VIN] VarChar (17) ,

VIC VarChar (10) ,

MODELYEAR VarChar (4) ,

MAKE VarChar (17) ,

MODEL VarChar...

[MVG T003 - Eliminate outliers from T001] it is a table and [CurMileage] it is a column

and yes it is only one source for both

yes, it is a mathematical operation:

In Access this way:

Sum(([MVG T003 - Eliminate outliers from T001]![CurMileage]-[CPM T001 - Calc avg cur mileage & proceeds]![AvgOfCurMileage])^2) AS [Reg Equation Slope Denomator]

In SQL this...

thanks