Solved

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

Posted on 2004-08-02
3
158 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 50 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

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 …
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

707 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