DAP didn't return any records when I used a Like clause in the que



The data access page (DAP) I created based on a query that contained a Like
clause didn't return any records. Is this a known issue with DAPs?


DAPs based on similar queries that didn't use Like clauses work fine.

--
Christian Bahnsen
.



Relevant Pages

  • Re: Cannot Edit records through a Data Access Page
    ... Data Access Pages are more often noneditable because the query does not ... DAPs often won't ... > edit the records through a form, but the same form saved as a Data Access ...
    (microsoft.public.access.gettingstarted)
  • Re: DAP didnt return any records when I used a Like clause in the que
    ... Perhaps you used * as a wildcard character? ... DAPs use ADO recordsets, not DAO ... clause didn't return any records. ...
    (microsoft.public.access.dataaccess.pages)
  • Insert statement
    ... I have an Access application that uses DAPs. ... TrackingID and TrackingSeq as the primary key, ... What I want to do is insert a Tracking record each time a new project is ... I tested my theory in the Access Query module. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Allow users to input in a data access pages form?
    ... there is a newsgroup reserved for DAPs: ... what is the connection string used? ... >I am setting up data access pages. ... > and queries. ...
    (microsoft.public.access.forms)
  • Re: How do I update a DAP based on a query?
    ... You'll need to look at the Properties (data tab) for the specific group or ... I do have the primary key include. ... > UniqueRecordSet in the query. ... >> DAPs are less tolerant of queries than forms. ...
    (microsoft.public.access.queries)

Loading