Duplicate fields in reports - never happened before

  • Thread starter Thread starter S Stewart
  • Start date Start date
S

S Stewart

Hi,

I'm using Access 2002, but the database is in Access 2000 file format.
The database is split, with the front end on users PCs, and the
backend on the server. The backend tables hold the data, the front
end is linked to the tables on the backend, and the front end holds
all the reports, queries, macros, etc.

Suddenly all my reports are giving me duplicate information, where
they never did before. We have class reports, transportation reports,
every single report now lists two of every person and their
information. So instead of 12 lines of information, we have 24 lines
of information.

I have been working with the database, adding new tables,
relationships, new forms, new reports. No telling what exactly I did
that caused the problem. I generally work on a copy of the database
and if everything seems to work okay after making changes, I copy the
new version over the old copy (saving it first).

It seems to be a problem with the backend tables because I've tried
using my archived front end tables and get duplicates. However, if I
go back to three weeks ago's back end tables and link the current
front end tables to those, then I no longer get the duplications. I'd
rather not copy the three week old data tables over the current one
because we'll lose three weeks worth of data input in the last three
weeks.

If anyone can give me any suggestions on why I'm getting duplicates
when we never did before, I'd be grateful. I didn't want to make this
too lengthy, so please let me know if you need more information.

Thanks in advance,
Starlene
 
S said:
I'm using Access 2002, but the database is in Access 2000 file format.
The database is split, with the front end on users PCs, and the
backend on the server. The backend tables hold the data, the front
end is linked to the tables on the backend, and the front end holds
all the reports, queries, macros, etc.

Suddenly all my reports are giving me duplicate information, where
they never did before. We have class reports, transportation reports,
every single report now lists two of every person and their
information. So instead of 12 lines of information, we have 24 lines
of information.

I have been working with the database, adding new tables,
relationships, new forms, new reports. No telling what exactly I did
that caused the problem. I generally work on a copy of the database
and if everything seems to work okay after making changes, I copy the
new version over the old copy (saving it first).

It seems to be a problem with the backend tables because I've tried
using my archived front end tables and get duplicates. However, if I
go back to three weeks ago's back end tables and link the current
front end tables to those, then I no longer get the duplications. I'd
rather not copy the three week old data tables over the current one
because we'll lose three weeks worth of data input in the last three
weeks.

If anyone can give me any suggestions on why I'm getting duplicates
when we never did before, I'd be grateful. I didn't want to make this
too lengthy, so please let me know if you need more information.
Click to expand...

I would start by examining the tables involved in the
changed relationships. It kind of sounds like you had a
table with one record that is joined to other tables and
somewhere along the line that table now has two records (or
something like that?).
 
Marshall Barton said:
I would start by examining the tables involved in the
changed relationships. It kind of sounds like you had a
table with one record that is joined to other tables and
somewhere along the line that table now has two records (or
something like that?).
Click to expand...

Okay, I will try that. I've examined the relationships and those
appear to be as they should be. And from what I can tell, the
duplicating problem is happening only to the reports that come from
two tables. The information in the tables is not duplicated... I also
realized that I should be able to save all the data from the tables,
then replace the backend tables that have a problem with the one that
is okay and then move the data back in. There are 8 tables holding
data that have to be replaced if I can't figure out what went wrong.

Thanks very much.
Starlene
 
S said:
Okay, I will try that. I've examined the relationships and those
appear to be as they should be. And from what I can tell, the
duplicating problem is happening only to the reports that come from
two tables. The information in the tables is not duplicated...
Click to expand...

Here's another thought. Double check the reports' record
source queries, run each one from the query design window
and make sure that the datasets are as they should be.
 
Back
Top