How do I set this option without SQL Server? (Arithabort)

[idbands]

We have a 3rd party application that we use that uses SQL Server. I don't know too much about SQL Server; I think we only have the client version installed?

I can access the SQL Server tables through Microsoft Access (via the SQL Server ODBC driver) and run lots of queries and updates which I do often.

Currently, I have run into an issue though. I need to insert a record into a table and I am getting an error about Arithabort not allowing me to do the insert. I've been told and read online that I just need to set Arithabort to "OFF" somewhere. . .where/how do I do this?? I think it's somewhere in the ODBC connection setup but I'm having no luck.

Can anyone help?

 

[djj55]

Have you tried one of the Access forums?

 

[idbands]

I wasn't sure which forum to try. I'll try that.

Thanks!

 

[bborissov]

You better check where you divide by zero in your query or have some overflow of the values in the table.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.