I have a database written in Ac2K. I have many Word documents in Word2K. I recently upgraded to Office 2003. Mail merge works OK in the old version, doesn't find queries in new.
The difference between the 2 is this: When I open a “merge” letter they both ask for the data source. In the older version of Word a box pops up titled "Microsoft Access" and inside the box I have two options, one to select a table and the other to select the query. I went to query, selected it, noticed at the bottom of the screen it said “Starting Access” and IT WORKED!
In the newer version of Word when I go to get the datasource I get one box to pick from called tables. When I click on the query via this it does not run – so there is the problem – in the newer version I need to see a box that has the two choices to select from: Tables or Queries.
I am reluctant to convert the Ac2K to Ac2003 because other users still have Ac2K. I've checked search and other postings and have already checked the "convert on opening" suggestion I found. Anybody have an idea to make this merge work?
The difference between the 2 is this: When I open a “merge” letter they both ask for the data source. In the older version of Word a box pops up titled "Microsoft Access" and inside the box I have two options, one to select a table and the other to select the query. I went to query, selected it, noticed at the bottom of the screen it said “Starting Access” and IT WORKED!
In the newer version of Word when I go to get the datasource I get one box to pick from called tables. When I click on the query via this it does not run – so there is the problem – in the newer version I need to see a box that has the two choices to select from: Tables or Queries.
I am reluctant to convert the Ac2K to Ac2003 because other users still have Ac2K. I've checked search and other postings and have already checked the "convert on opening" suggestion I found. Anybody have an idea to make this merge work?
