[AccessD] Data on Report does not match data in the Report's RecordSource

Jim Dettman jimdettman at verizon.net
Sun Oct 16 19:59:36 CDT 2011


 Watch out with reports; 2007 introduced Report View, which will show you
odd data at times.  Lots of strange things can happen there as most of the
report events don't fire. If your depending on any code to support the
report, you may see different things.   Sounds like your problem is more
then that though.

  I'd also look at database corruption; create a new DB and import
everything into it, then see if you get the same results.

  If you do, that would be wild; I've never heard of anything even remotely
close to this.  I would also seriously doubt it could be wide spread as 2007
has now been out for over four years.

  It would be good if you could go into a little more detail on what it is
your seeing.  Ie. more records?  Different field values for the same
records?  

 Keep us updated....

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Sunday, October 16, 2011 05:14 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Data on Report does not match data in the Report's
RecordSource

All,

I believe that this is the strangest thing I have ever seen in Access
2007.

We have a purchased package which uses a Firebird Database. All of the
tables are defined by the application vendor.  We are able to access the
Firebird tables from Access 2007 via ODBC.  This combination has worked
nicely in numerous tests that we have conducted over the past 2-3
months. 

A few days ago, I happened to notice that the data on one report does
not match the data in the Report's Record Source (a query).  I have
conducted many tests on two different PCs and the results are
consistent.  The data on the report is correct, but the data in the
underlying Record Source is not correct.  If I look at the Access
"Linked Table" (Which is stored in the Firebird Database), the data is
not correct (but I can make it appear correct by doing a Refresh in
Access). 

If I view the data with the Firebird Utility called "isql", the data is
correct.

I have spent many hours trying different things and running various
tests (and pulling my hair out).


In summary...

Data on Report = Correct

Data from Firebird "isql" utility = Correct

Data in Report's Record Source (query) = Not Correct

Data shown by viewing "Linked Table" = Not correct (although I can make
it appear correct by doing a "Refresh" in Access) 

Data as viewed via the purchased application = Correct

We have conducted many tests with the Firebird Database - Access 2007
combination over the past few months, so we have some experience, but
not a huge amount.

My latest theory is that the problem lies in the ODBC driver.

This would explain why the data appears correct with isql but appears
incorrect when initially viewed as an Access 2007 Linked Table.

However, this still doesn't explain why the data on the report is
correct when the data in the report's record source is incorrect.

Has anyone ever heard of anything like this before?

Has anyone worked with Access in combination with data from Firebird
database tables?

Thanks for your help,

Brad   


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list