• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 185
  • Last Modified:

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,
0
bfider2004
Asked:
bfider2004
  • 2
1 Solution
 
alexhoganCommented:
Do you have the database open in access at the same time you are checking the page?
0
 
bfider2004Author Commented:
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,
0
 
alexhoganCommented:
Yes..,

Usually when you see this error it means that you have the access file open someplace else.  You will be able to duplicate this error by opening the access file and then testing the page at the same time.

If you have another connection open on the same page it could be interferring with the connection that you are trying to access.

Also if you haven't closed the connection on the page you will have a temp file that is open with an .ldb extension.  If this file still exists in the directory with the database, delete it then test the page again.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now