请教一个问题： 在查找中老出现： 错误类型： Microsoft OLE DB Provider for ODBC Drivers (0x80040E07) [Microsoft][ODBC Microsoft Access Driver] 内存溢出 /hezuo.asp, 第 17 行 是怎么回事？

,版主在吗？帮帮忙解决了

17行是啥？？

还有你的数据库多大？？

上面的日文会导致access在搜索时出错，就是内存溢出，在sql下不会有这种问题，要在access下解决的话在储存和读取时用下面的函数

储存 Function jp2code(CodeStr) jp2code=Replace(Replace(Replace(Replace(Replace(CodeStr,"ガ","j30AC"),"ギ","j30AE"),"グ","j30B0"),"ゲ","j30B2"),"ゴ","j30B4") jp2code=Replace(Replace(Replace(Replace(Replace(jp2code,"ザ","j30B6"),"ジ","j30B8"),"ズ","j30BA"),"ゼ","j30BC"),"ゾ","j30BE") jp2code=Replace(Replace(Replace(Replace(Replace(jp2code,"ダ","j30C0"),"ヂ","j30C2"),"ヅ","j30C5"),"デ","j30C7"),"ド","j30C9") jp2code=Replace(Replace(Replace(Replace(Replace(jp2code,"バ","j30D0"),"ビ","j30D3"),"ブ","j30D6"),"ベ","j30D9"),"ボ","j30DC") jp2code=Replace(Replace(Replace(Replace(Replace(jp2code,"パ","j30D1"),"ピ","j30D4"),"プ","j30D7"),"ペ","j30DA"),"ポ","j30DD") jp2code=Replace(jp2code,"ヴ","j30F4") End Function

读取 Function code2jp(CodeStr) code2jp=Replace(Replace(Replace(Replace(Replace(CodeStr,"j30AC","ガ"),"j30AE","ギ"),"j30B0","グ"),"j30B2","ゲ"),"j30B4","ゴ") code2jp=Replace(Replace(Replace(Replace(Replace(code2jp,"j30B6","ザ"),"j30B8","ジ"),"j30BA","ズ"),"j30BC","ゼ"),"j30BE","ゾ") code2jp=Replace(Replace(Replace(Replace(Replace(code2jp,"j30C0","ダ"),"j30C2","ヂ"),"j30C5","ヅ"),"j30C7","デ"),"j30C9","ド") code2jp=Replace(Replace(Replace(Replace(Replace(code2jp,"j30D0","バ"),"j30D3","ビ"),"j30D6","ブ"),"j30D9","ベ"),"j30DC","ボ") code2jp=Replace(Replace(Replace(Replace(Replace(code2jp,"j30D1","パ"),"j30D4","ピ"),"j30D7","プ"),"j30DA","ペ"),"j30DD","ポ") code2jp=Replace(code2jp,"j30F4","ヴ") End Function

<SCRIPT language=JavaScript src=\"/netbei/x/view_a2.js\">

</script>

17行Rs.open "Select * From 合作转让 where 项目名称 like '%"&keyword&"%' or 项目介绍 like '%"&keyword&"%' and 发布 = True order by 时间 DESC",Conn,3,3 数据库很小的.才十几兆.

其他分类的查询都这样写,没错,可是唯独这个就有问题?

有没有日文

没有日文

不过数据库是ACCESS.