Divide by Zero on SQL PassThrough Query

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

Hi,

I am getting this Divide by Zero Error on SQL Pass
Through Qery from Access 2002. When i copy and Paste the
same query in SQL Server Query Analyzer, it runs fine
without giving me "Divide by Zero Error".

What am i doing wrong ? Please help !
 
hey Folks,

I have found the answer myself.
Make a backup Copy of your Database
All you need to do is go to Tools->Options->Tables/Queries
and Check the Box for This Database under SQl Server
Compatible Syntax(ANSI92)
Access will Close, Compact and reopen the Database and
now your query should Run fine.

Thanks,

Sam
 
Back
Top