>>Given the following code:
>>

>>< %
>>Set oConn = Server.CreateObject("ADODB.Connection")
>>ConnStr = "Driver=Microsoft Visual Foxpro Driver; UID=userID;SourceType=DBC;SourceDB=G:\INetPAG\TIPApplication\RegionalBids\Data\bidsdata.dbc"
>>oConn.Open ConnStr
>>
>>lcUser = trim(request.form("user"))
>>lcPassword = trim(request.form("password"))
>>lnAuthlevel = -1
>>
>>if lcUser <> "" and lcPassword <> "" then
>>   sql = "select * from users where username = '" & lcUser & "' and password = '" & lcPassword & "'"
>>   Set oUser = oConn.Execute(sql)
>>   lnAuthlevel = cdbl(oUser("authorization"))
>>   session("authlevel") = lnAuthlevel
>>end if
>>
>>if lcUser <> "" then
>>if lnAuthlevel > 0 then
>>     sql = "insert into xlogins (username) values ('Test')"
>>     set oLogin = oConn.Execute(sql)     && it fails here
>>end if
>>end if
>>% >
>>

>>reading and verifying the login works fine. But the attempt to record the login into the xlogins table results in an error that says 'unable to update the cursor'. Am I missing something simple or is there another technique needed here?
>>
>>Thanks
>
>It's a security issue. You don't have write access to data.
>
>Also I suggest VFPOLEDB driver instead of ODBC driver:
>
>

>Set oConn = Server.CreateObject("ADODB.Connection")
>ConnStr = "Provider=VFPOLEDB;" & _
> "Data Source=G:\INetPAG\TIPApplication\RegionalBids\Data\bidsdata.dbc"
>

Cetin

Cetin -
I swapped your code for mine. It still works the same. I DO have write access to the data via VFP if I open it in the development environment. Is there something special I need to do in the asp page to open it for write access?

- Don