Driver Errors 1

missippi · Mar 30, 2002

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
/RegisterUser1.asp, line 9

I keep getting this error when I am trying to update my access database user information.

I have a basic form.html page that accepts users information and does a post to this page.

my database is just a baisc access 2000 database that has a tblUsers table in it.

Thanks!

Missippi
__________________________________________________________
<%@ Language=VBScript %>
<% Option Explicit %>


<HTML>
<BODY>
<%
Dim objRS, bolAlreadyExists
If ((Request.Form("username&quot

= "&quot

OR (Request.Form("password&quot

= "&quot

_
OR (Request.Form("email&quot

= "&quot

OR (Request.Form("firstname&quot

= "&quot

_
OR (Request.Form("lastname&quot

= "&quot

) Then
Response.Write "<A HREF='register.html'>"
Response.Write "You must enter values for all the fields."
Response.Write "</A>"
Else
BolAlreadyExists = False
Set objRS = Server.CreateObject("ADODB.Recordset&quot

objRS.Open "tblUsers", objConn, , adLockOptimistic, adCmdTable
Do While Not (objRS.EOF OR bolAlreadyExists)
If (StrComp(objRS("Username&quot

, Request.Form("username&quot

, _
vbTextCompare) = 0) Then
Response.Write "<A HREF='register.html'>"
Response.Write "Username already exists."
Response.Write "</A>"
bolAlreadyExists = True
End If
If (StrComp(objRS("Email&quot

, Request.Form("email&quot

, _
vbTextCompare) = 0) Then
Response.Write "<A HREF='register.html'>"
Response.Write "Email address already found in table."
Response.Write "</A>"
bolAlreadyExists = True
End If
objRS.MoveNext
Loop
If Not bolAlreadyExists Then
objRS.AddNew
objRS("FirstName&quot

= Request.Form("firstname&quot

objRS("LastName&quot

= Request.Form("lastname&quot

objRS("Email&quot

= Request.Form("email&quot

objRS("Username&quot

= Request.Form("username&quot

objRS("Password&quot

= Request.Form("password&quot

objRS.Update
Response.Write "Thank you for registering."
End If
objRS.Close
Set objRS = Nothing
End If

%>

</BODY>
</HTML>

_______________________________________________________

rtshort · Mar 30, 2002

Well, sorry I can't answer your post, I just started dabbling in ASP a week or so ago.

I am however from MS and was just wondering what part of the state you are from. Rob
Just my $.02.

missippi · Mar 30, 2002

Ovatvvon · Mar 30, 2002

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
/RegisterUser1.asp, line 9

The error tells you the problem. "...Database or object is read-only."

You need to go to the properties of the database and make it an archive, not 'read only'. Either that, or you need to make the folder it is contained within possess the permissions to allow the IUSER_(computername) to do more than read the files. Give them access to update, delete, etc.

-Ovatvvon :-Q

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Driver Errors 1

missippi

IS-IT--Management

rtshort

IS-IT--Management

missippi

IS-IT--Management

Ovatvvon

Programmer

Similar threads

Part and Inventory Search

Sponsor