Database

[Mettá]

Hi

Within a DRW custom query what is wrong with the following, I am getting the
proverbial Database Results Error
The operation failed. If this continues, please contact your server
administrator.

SELECT Subject, Dte, Left(Text1,70) As Description30 FROM tTexts WHERE
(Text1 LIKE '%::Text1::%' OR subject LIKE '::Text1::%') ORDER BY Subject ASC

Win 2003 server with 2002 extensions
Access 97 db on dsn less connection

Thanks
M

 

[Kathleen Anderson [MVP - FrontPage]]

What version of FrontPage?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx

 

[Mettá]

FP2002 although I sometimes use 2003!

M

 

[Thomas A. Rowe]

You might want to consider updating the database to at least Access 2000, as there are problems with
the most recent MDACs and Access 97 databases.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================