synchronization of Access 2003/SQL 2005

  • Thread starter Thread starter Hector
  • Start date Start date
H

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?
 
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
 
Back
Top