Divide by Zero on SQL PassThrough Query

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 !
 
S

Sam

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to display zero value in blank fields of Cross Tab query 0
query with zero records 6
Parameters, Passthrough UpdateQueries, and SQL 7
Divide by Zero on SQL Pass Through Query 1
Passthrough query 3
SQL query 1
Query on SQL Server is fast, while Access is crawling 2
Max SQL length for Passthrough Query 2

Top