Link to home
Start Free TrialLog in
Avatar of bfider2004
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.ActiveConnection = MM_editConnection

And this comes after the sql insert code:

' *** Insert Record: construct a sql insert statement and execute it


Any ideas?

Thanks,
Avatar of alexhogan
alexhogan

Do you have the database open in access at the same time you are checking the page?
Avatar of bfider2004

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,
ASKER CERTIFIED SOLUTION
Avatar of alexhogan
alexhogan

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial