I am attempting the Dreamweaver MX tutorial and when I click submit on my insert loaction page I get this After turning off friendly msgs I got this error

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file
already in use.

/Sample App/TMPsepvxx9oux.asp, line 113


Line 113: MM_editCmd.ActiveConnection = MM_editConnection
I have tested the connection in the setup and it connects fine What am i doin or not seeing?

I need to get past this, any help greatly appreciated

This is a page that list a bunch of common server errors, and lists the one that you mentioned several times.
www.macromedia.com/support/ultradev/ts/documents/common_server_errors.htm

Here is the exact error with answers on how to correct it...
www.macromedia.com/support/ultradev/ts/documents/80004005_win2k_error.htm


(UD4|IIS5|WXP|ASP)
*Connman21*
www.conncreativemedia.com

Edited by - connman21 on 06 Jun 2002 07:39:34

Hey thanx for the reply,

I am not a newbie with permissions but I am still a bit confused , I assigned the permissions in the IIS MMC but that did not seem to work

for testing porposes I have made the user account an admin now it will attempt to update the database if i restart dreamweaver and the global.ldb gets removed. It is obviously locked I must be doing something wrong. When I resatart dreamweaver it will attempt to update the database but I get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Field 'LOCATIONS.LOCATION_NAME' cannot be a zero-length string.

/Sample App/TMPcbrlfxaeo7.asp, line 115

---------------------------------------------------
I am assuming that I have something messed up in my config on how the page is referencing these fields. Again sorry if my questions seem to basic or Im overlooking something its just that I have been forced into this situation and as always under a tight timeline.

Any additional thoughts appreciated, Again sorry for my newbieness (is that a word? feels like it should be)

Christian

As far as the 'Zero-length String' error that is because you submitted a field with nothing in it, and in your Access field settings you say that it is mandatory. Go into your DB and in Display View change the settings on the field to allow 'Zero Length Strings'...


(UD4|IIS5|WXP|ASP)
*Connman21*
www.conncreativemedia.com

Hey!,

Cant thank you enough , that gets me over the basic understanding of this.

Greatly appreciated,

Christian