Solved

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

Posted on 2004-08-02
3
146 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 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Unable to Connect Via FTP 109 1,228
Resume template for HTML/Dreamweaver website 9 510
WordPress on local PC and hosted 11 144
.dwt files not viewable in browser - why? 2 72
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…
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

932 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now