Working with an MS Access database from an ASP webpage and I'm getting an
/Projects/App/Mypage.asp, line 184
The SQL statement looks like so...
strSQL = "SELECT Cat, MyNote FROM Notes WHERE KeyLink = " & SelKey
rsSet.Open strSQL, adoCon
Cat is a 10 character text field, MyNote is a Memo field (and I think the
memo field is causing the issue), KeyLink is a number, as is the variable
I can't update or change any of the components/software on the server.
Can someone explain why this is happening? I've found a ...