subquery memo type

[vlad123]

I have 2 tables like this: dbo_link
and tmp_link. I want to delete all records from dbo_link that are in tmp_link also. the problem is that the field url from both tables is a memo field, and I cant use a memo field in a subquery.

strsql2 = "delete * from dbo_link where dbo_link.url in (select url from tmp_link)"
DoCmd.RunSQL strsql2

Invalid Memo, OLE, or Hyperlink Object in subquery <name>. (Error 3342)
A subquery cannot return a Memo or OLE Object, and it cannot be compared to a Memo or OLE Object in an expression.

 

[mikej336]

Any reason you could not change the URL field to a txt field?

Or if not, create a temp table where URL is a txt field. Copy your records out, run your sub-query then clear your new temp table.

Uncle Mike