need access query

kale_tushar · January 2nd, 2005, 02:30 PM

this is query in sql i want its equivalent for access databse...this is used for searching thru database..asp.net technology

SELECT RANK, u_id, u_title FROM Uploads FREETEXTTABLE( Uploads, *, @searchphrase ) searchTable WHERE [KEY] = uploads.u_ID ORDER BY RANK DESC

please help

jemacc · January 3rd, 2005, 01:59 AM

view this article it should help

http://support.microsoft.com/kb/q208946/

Jaime E. Maccou

kale_tushar · January 3rd, 2005, 05:26 AM

Thanks for reply...

But still i cant write it from that article...

Help still needed

Thnx