Query using ADO returns no data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know very little about Access, but got stuck trying to support it. I
received the following email and have no clue how to help. Any ideas?

Thanks,
Carla

Detail_Description:
Query using ADO does not return data. Anytime, I attempt to use a "WHERE"
clause to filter data the query returns no data; however, while testing the
query interactively within access it performs as expected. When the "WHERE"
clause is removed it again performs as expected.

system specs: VBA 6.3.8863
Access 2002 (10.4302.4219) SP-2
Reference library--ADO 2.7
 
Might be the wildcard thing - % and _ in place of * and ? - but without
seeing the SQL that's just a guess.
 
Back
Top