Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[ Microsopft Access ODBC Driver ] Can't Update database. Database or Object is read only

0 views
Skip to first unread message

Vaggelis T.

unread,
Oct 25, 2006, 4:03:24 PM10/25/06
to
What is the problem with my code?
Set con = Server.CreateObject("ADODB.Connection")

strcon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("Customers.mdb")
Con.open strcon

set rs = server.CreateObject ("adodb.recordset")
rs.Open "CustomerTable", Con,adOpenDynamic , adLockOptimistic, adCmdTable
rs("Name") = gName
rs("Address") = gAddress
rs("Phone") = gPhone
rs.Update
rs.Close
Response.Redirect "display_issue.asp?" & IssueNumber
set rs = nothing

Con.close
set Con = nothing

Thanks


Vaggelis A.Tsiakiroudis


0 new messages