synchronization of Access 2003/SQL 2005

[Hector]

I have a db on Access 2003 that links to tables from SQL 2005.

Some records display via forms with the correct info, but then I run a
report for those records, the report shows wrong data.

If I go back to reverse the procedure that pulls the data to display and
then redo the reports, then the data reflected on the reports is fine.

It seems like the first time the calculations to generate the report are
either too fast or too slow for the values to be saved into the tables, so
when the report runs the data is messed up. But when the process is undone
and redone, then the data is fine.

Any ideas?

 

[Alex Dybenko]

Hi,
never saw this, perhaps something wrong with your code? Do report and code
uses same query? Try to use pass-through queries for reports if you are not
using them yet

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Tom van Stiphout]

On Thu, 21 Aug 2008 12:56:13 -0700, Hector

That's not how things normally work, so you'll have to provide a lot
more information for us to understand what's going on.

-Tom.
Microsoft Access MVP