What steps will reproduce the problem?
1. Running the same Access queries against both SQL and Access based data
do not always yield the same results
What is the expected output? What do you see instead?
Identical results for the same time periods modeled across the Access and
the SQL side - for the same data. This was NOT the case many times.
What version of the product are you using? On what operating system?
Access 2001. SQL/Express (SQLServer 2005)
Please provide any additional information below.
I am finding that not all databases are the same when it comes to treatment
of numeric results. In my (somewhat desparate) moving of the GRID model
over to SQL, though I was finally able to get results, I am finding that
not all results for the same time periods from previous runs in Access come
out with the same results. I made the (likely wrong) assumption that
sending the SQL server data through the same Access queries would result in
identical results. NOT always the case, apparently - though I am still
investigating that.
What is unclear to me is what happens when you have Access as the FRONT end
and SQL as the BACK end. I KNOW for certain that I encountered issues with
TRUNCATION (where SQL results came through truncated - NOT rounded - though
not consistently).
Now I am also learning from Issac that the way SQL treats things like
expotential functions in SQL is different from what he found in Access for
the same SQL code.
I suggest more research and certainly more testing along these lines,
particularly as we are moving to transition more SQL transactions from our
Access base to SQL.
Likely more to come on this.
Original issue reported on code.google.com by mark.li...@gmail.com on 26 Jan 2010 at 7:07
Original issue reported on code.google.com by
mark.li...@gmail.comon 26 Jan 2010 at 7:07