Help, I used the insert record server behavior to insert my data from a new user register form. I keep getting this same error.
Microsoft ole db driver... 80040E14 Syntax error in FROM clause.

the line it gives me is here:
MM_rsKey.Open();

if I go up a few lines I find this line:var MM_dupKeySQL = "SELECT myradfn FROM login table WHERE myradfn='" + MM_dupKeyUsernameValue + "'"

I found the SQL quote problem on microsoft's knowledge base but I'm lost.
If you need more of the code let me know.
If I try to test a resord set, I get the same error.

Please help!

Mike

Thanks all I got it working!!!