exception opening access db

after the "Open" of an msaccess table an "Invalid Floating Point Operation" exception is raised.

why it happend? Please help me. Thank's

alex@daskalos.com

I got similar errors when converting databases between Access and SQL Server. It turned out that Currency columns that contained null values were not interpreted as having a zero value when I was accessing them "AsCurrency".

A little routine that put zeros into every null currency solved the problem.

Hope this helps.