Philip,
Don't know if you're over-tired, but this is definitely possible using
both Access 97 (my version is 2-3 years old at least) and Access 2000.
--John
Philip Arnold - ASP wrote:
>
> > If I understand your statement correctly, I think I have to take issue.
> > I have a newsletter app I've been working on where the following code
> > works just fine (article_text is an Access memo field, and criteria is
> > the form field):
> >
> > WHERE article_text LIKE '%#criteria#%'
> >
> > Maybe an exception to the rule?
>
> Was this added in one of the MDAC updates? When I last used Access as an
> ODBC datasource (about 2 years or so ago) you couldn't do this, and you
> definitely can't do it (directly) with SQL Server... maybe in the updates
> they got around this problem... or am I just over-tired?
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **********************************************************************
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
