merging with MS word - lost queries

[tinyowl]

Hello. I created two access applications in Access 2000. These databases where constructed for different purposes, (I should emphasise that these separate applications are in no way linked to each other) They both use a procedure for choosing costumer information from a customer information table which was then accessed by MS Word for a mail-merge procedure. I have set up mail-merging several times between MS Word and Access. These systems have worked reliably for several years.

I am now running the same two sytems in MS Access 2010 and there is no incomaptibility. However in one application it is possible to set up the mail merge in the usual way i.e. selecting a query from a list to obtain the information for the merge. In the other application Access 2010 software only displays a very limited set of tables and queries to choose from, one of the absent one being that which I need for merging.

I have been unable to fix this problem. Any advice would be most welcome.

I did post this problem on Access other problems without success so I thought an airing in this forum may be a good idea.

 

[SkipVought]

hi,

Longshot...

In the query dialog, before listing tables, look for an OPTIONS button that has several check boxes. They ALL need to be checked.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[tinyowl]

Have been away from the project for several days. Thank you for your reply, however -

Which options are you referring to? Are they in access itself or during the merging process?

I have not seen a display of options.

don