Database Results Wizard Error Works on Local Not on Server

D

Dave

Database Results Wizard Error
The operation failed. If this continues, please contact
your server administrator.

This works on my local server when I publish to the server
I get the error above. I'm using Access Database with a
view. The database has been published also. Here is the
Query

SELECT newsLetter.datePublished, "<a href=" & '"..' &
newsLetter.newsletter_link & '">' &
newsLetter.newsletter_display & "</a>"
FROM newsLetter
ORDER BY newsLetter.datePublished;

Why do I get this error and is there anyway to get more
debug information than the message i listed above?
 
D

Dave

Thanks for the tip. It worked. Here is the error I'm
getting
Database Results Wizard Error
Description: Syntax error in query. Incomplete query
clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

The Query works fine in Access itself. It also works on
my local site. The Access database is contained in the web
site. I don't believe that Access software is running on
the server. We are running Microsoft Server 2003 on the
server. What is the MicroSoft Jet Database Engine and
where might I find the proper syntaxs for it?
Your replys to everyone's problems are always very
helpful.
Thanks
Dave
 
Top