Access and ASP - DW's "Check New Username" behavior isn't working properly
Posted on 2004-08-02
I have a form for users to create a login account. Their email is to be their username. I am using DW's Check New Username behavior to ensure no two same email addresses are used. So, I have form with fields Fname, Lname, Email, LogPassword. The form is to check to see if Email is unique (if not it redirects to a Email Exists page) and then insert the record into the Access database.
I enter a email address that I know is in the table, and the check new username seems to work, as I'm redirected. But, when I enter new info into the form, I get this error:
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
/bonedisease/login/create.asp, line 139
And line 139 is:
MM_editCmd.ActiveConnection = MM_editConnection
And this comes after the sql insert code:
' *** Insert Record: construct a sql insert statement and execute it