Query gives different results

C

Carolyn Kay

Running a make-table query manually in an Access 2002 database returns 58
records. Running the same query from a Word 2002 macro using the code
below, returns only 18 records. The path is correct, and the code is
accessing the correct database.

Set aApp = New Access.Application
aApp.OpenCurrentDatabase thisPath & "Reports.mdb"
aApp.DoCmd.OpenQuery "ValuationDataQuery", , acReadOnly

The environment is an NT network with XP on the client machines. If I run
the query on my XP only machine, I get the same results from the query
whether I run it manually or use the above code.

I'm out of ideas. What can I try to fix the problem?

TIA, Carolyn Kay
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top