Access query on works when Excel is running

[wemeier]

I have a STRANGE problem that I cannot figure out. I have an Excel97 worksheet linked as a table in Access97 I'm comparing prices on the worksheet to prices in an Access table.

When I run the comparison checking for [AccessPrice]<>[ExcelPrice] the query returns rows where the [AccessPrice] and [ExcelPrice] are the same. I've checked the data in both the Access table and the Excel worksheet and both raw values are the same (to make sure I wasn't just seeing a rounded number).

When I add the expression Expr1:[AccessPrice]-[ExcelPrice] to the query, it returns some VERY tiny differences (for example, -1.110223E-16).

Now comes the strangest part -- when I open the worksheet in Excel and, while Excel is still up, rerun the Access query the rows are not returned! As soon as I close Excel and rerun the query the rows reappear.

I've tried resaving the worksheet in earlier versions of Excel, but can't fix the problem. I could try importing the data into an Access table first, but I'm trying to avoid that because I don't want database bloat when I don't need it.

Cruising the Information Superhighway
_{(your mileage may vary)}

 

[wemeier]

Just a follow-up. Both the Access table field and the Excel worksheet field are identified as type Double, so there's no datatype difference.

Cruising the Information Superhighway
_{(your mileage may vary)}