Dim objConn
objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=DCTRepair"
objConn.Open()
Dim objRS
objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open("TechEntry", objConn, 2, 3, 2)
objRS.AddNew()
objRS("SerialNumber") = TextBox1.Text
objRS("TechNumber") = TextBox2.Text
'objRS.MoveLast()
objRS.Update()
objRS.MoveFirst()
objConn.Close()
objConn = Nothing
End Sub
The code above works fine till I try to update or use the MoveLast
option for the database. Any ideas?
Alexey Smirnov - 13 Dec 2007 07:45 GMT
> Dim objConn
> objConn = Server.CreateObject("ADODB.Connection")
[quoted text clipped - 17 lines]
> The code above works fine till I try to update or use the MoveLast
> option for the database. Any ideas?
Stephen, sounds like you don't have modify permissions at the
directory where the database is located, or a database file is read-
only.
Mark Rae [MVP] - 13 Dec 2007 08:45 GMT
> Any ideas?
You're in the wrong newsgroup - this group is for ASP.NET.
For ASP Classic issues please post to
microsoft.public.inetserver.asp.general

Signature
Mark Rae
ASP.NET MVP
http://www.markrae.net