Whenever I try to execte a delete query using a sqloledb connection I get the
following message:
“The column prefix ‘WEBAPPS.DBO.MDUCMPLX_RANGES_VID' does not match with a
table name or alias name used in the query”
Do I need to change the qyntax?
below is the query

DELETE FROM WEBAPPS.DBO.MDUCMPLX_RANGES_VID
WHERE WEBAPPS.DBO.MDUCMPLX_VID.VID = 27

Hi,
check that you are really connected to sql server you need. Just query
sysobjects to make sure table is there

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

"Alex" <(E-Mail Removed)> wrote in message
news:677DB5A6-4325-493F-845F-(E-Mail Removed)...
> Whenever I try to execte a delete query using a sqloledb connection I get
> the
> following message:
> “The column prefix ‘WEBAPPS.DBO.MDUCMPLX_RANGES_VID' does not match with a
> table name or alias name used in the query”
> Do I need to change the qyntax?
> below is the query
>
> DELETE FROM WEBAPPS.DBO.MDUCMPLX_RANGES_VID
> WHERE WEBAPPS.DBO.MDUCMPLX_VID.VID = 27
>