?
Solved

Access and ASP - DW's "Check New Username" behavior isn't working properly

Posted on 2004-08-02
3
Medium Priority
?
168 Views
Last Modified: 2012-05-05
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
Comment
Question by:bfider2004
  • 2
3 Comments
 
LVL 8

Expert Comment

by:alexhogan
ID: 11699365
Do you have the database open in access at the same time you are checking the page?
0
 

Author Comment

by:bfider2004
ID: 11700165
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
 
LVL 8

Accepted Solution

by:
alexhogan earned 150 total points
ID: 11700529
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Suggested Courses
Course of the Month12 days, 15 hours left to enroll

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question