Same Front End db gets different results from copy of back end

  • Thread starter Thread starter Paul Fenton
  • Start date Start date
P

Paul Fenton

I have a FrontEnd/BackEnd application running on a network. Typical
installation that's been running for several years. On my development
system here at home, I have a copy of the client's data file from
about 2 weeks ago. I also have a copy of his current datat file on my
development system.

My problem is that when I run the application, I get different results
from the two data files that can't be explained by their ages. Here's
what's happening:

There is a client record that exists on both back end files and has
not changed in several weeks. I've inspected this client's records in
every associated table in both db's and the records are identical
between the two versions.

There is a query that gets records of the client's tasks to be
performed, cost of the task, start date, balance due, etc.

This same query will produce different results from each database.

I have compressed and repaired, checked the relationships, examined
every table and every record for this client and can find no
differences.

Can anyboy point me someplace else to look?


Paul Fenton
(e-mail address removed)
 
Back
Top