"Jeff Dillon" wrote:

> Yes, give Everyone Full Control to the dbf directory. This is the same
> message one would get with Access with incorrect folder permissions. Also,
> for Access anyway, you needed to check for permissions on the TEMP and TMP
> directories, but this may have been only for previous versions of MDAC.
>
> Jeff
>
> "nick" <nbdy9.removet***@hotmail.com> wrote in message
> news:OY6bvz7xEHA.748@TK2MSFTNGP14.phx.gbl...
> > I have a class library to insert a new record into a dbf file. I always
> get
> > exception "Operation must use an updateable query" when the function is
> > called by a Asp.Net function. However, the insersion works well when I
> call
> > the function using NUnit. The following is the writing dbf code. Any clue?
> > Thanks.
> >
> > Class DAL
> >
> > static public function writedbf()
> > ...
> > Dim dbfConnectionString as String = "Provider=Microsoft.Jet.OLEDB.4.0;
> Data
> > Source=C:\dbfs;Extended Properties=dBase IV;User ID=Admin;Password="
> >
> > Dim InsertCmdStr As String = "Insert Into wolog (WOTYPE, REF_NO, PRIORITY,
> > Unit, DEPT, DEPT_ID, PAC2, RQNAME, RQPHONE, SHOP, ASTO, WODATE, OPTR,
> > LOCATION, COMM1, ESTHR, STATUS, UP, ROOM, FLR) values
> > ('D','D700804','5','90','740','1','2BUS','a','a','SEC','','11/10/2004
> > 2:02:27 PM','login','2  BUS ST a ','a ',0,'N','N','a','')"
> >
> > Dim cmd As New OleDbCommand(InsertCmdStr, New
> > OleDbConnection(dbfConnectionString))
> >
> > cmd.Connection.Open()
> > Try
> >     REF_NO = cmd.ExecuteScalar()
> > Catch err As Exception
> >     Throw err
> > Finally
> >     If Not cmd.Connection Is Nothing Then
> >         cmd.Connection.Close()
> >     End If
> > End Try
> > ....
> >
> >
>
>
>