bfider2004
asked on
Access and ASP - DW's "Check New Username" behavior isn't working properly
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.ActiveConnectio n = MM_editConnection
And this comes after the sql insert code:
' *** Insert Record: construct a sql insert statement and execute it
Any ideas?
Thanks,
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.
And line 139 is:
MM_editCmd.ActiveConnectio
And this comes after the sql insert code:
' *** Insert Record: construct a sql insert statement and execute it
Any ideas?
Thanks,
Do you have the database open in access at the same time you are checking the page?
ASKER
as in actually having the file open, or having a connection to the database open in the page?
it's on a remote host, so, it's not actually *open*. but there is a recordset on the same page that might be interfereing. is tht what you mean?
thanks,
it's on a remote host, so, it's not actually *open*. but there is a recordset on the same page that might be interfereing. is tht what you mean?
thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.