MS Access Error 3700

[Access/SQL Crazed]

When I try to run my pass through query, I get this error.

Below is the actual script in the query: procPrintInvoices 0,0,0,'449203'.

I executed the stored procedure in the SQL Server and it worked fine.

Does anyone have an idea?

 

[Stefan Hoffmann]

hi,

When I try to run my pass through query, I get this error.

Which error?


mfG
--> stefan <--

 

[RoyVidar]

hi,


Which error?


mfG
--> stefan <--

?AccessError(3700) -> Invalid precision for decimal data type

Perhaps if we see the SQL, and perhaps table/field definiton?

 

[Stefan Hoffmann]

hi Roy,

?AccessError(3700) -> Invalid precision for decimal data type

Ah, the subject, silly me.

Perhaps if we see the SQL, and perhaps table/field definiton?

The creation scripts of the SQL Server tables involved and the stored
procedure.


mfG
--> stefan <--

 

[Access/SQL Crazed]

I found the problem and fixed it.

Thanks.

hi,


Which error?


mfG
--> stefan <--