Merge not displaying queries

  • Thread starter Thread starter Rita
  • Start date Start date
R

Rita

I'm using Access 2003 and have a merge document set up. I have over 50
queries, but when I merge it's just listing a few queries. I vaguely
remembering doing something a little different to get the merge to display
all the queries--instead of selecting Access Database, it was DDE or
something like that?
 
I did put most merge documents into the database, but this merge document
creates an anniversary card. I'm merging a name, anniversary date, and years
of service--just 3 simple pieces of information. I'm using a graphic and
rotating text--I don't know how to do this in report or if it can be done.

It was working, but I revised the database and changed the query name that
it was accessing. When I click "Browse" to select the query, instead of
listing over 100 queries in my database, it's just giving me a few table and
about 7 queries (not the one I need).

Yesterday I click [x] confirm at startup--or something like that in Word. I
thought I tried merging again, but it still didn't list the queries. Today I
tried it and it worked!!!!! I'm not sure why though. When I open data source,
I need to select "Ms Access Databases vis DDE" for Access to display all my
queries.

I'm glad it's merging now, but I'd like to know what you have to do. I
created the database 13 years ago. I vaguely remember calling Microsoft (and
paying $100) for them to tell me I need to select DDE. Something about the
database being creating with an earlier version. I thought with upgrades
everything would be fine, but apparently since it was created in Access 97 it
used a different technology????

I design databases for a nonprofit, so they're slow to upgrade. We're
currently using 2003.
 
Back
Top