Oluwole
Thu Feb 05 11:27:20 CST 2004
Ok, I've sorted out my other problem as well. This site
(
http://support.microsoft.com/default.aspx?scid=kb;en-us;827190) explains it
all.
Regards.
Wole.
--
===============================
Life is not fair, get used to it!
God is fair, get Him!
"Oluwole Kolawole" <wole@k4plus.co.uk> wrote in message
news:%2377RLg%236DHA.2264@tk2msftngp13.phx.gbl...
> Tx Bill,
>
> That has gotten rid of that error, but now I'm stuck with another one. I
> started getting the error "operation must use an updateable query" which I
> found out means that there was a problem with permissions to the Access
> database or directory (or both). After fooling around with permissions and
> rights, etc, I'm now getting the error "unspecified error" when I try to
> open the connection (cn.open();)...and it's driving me up the wall. Any
> ideas will be gratefuly received.
>
> Regards.
>
>
>
> Wole.
> --
>
>
>
> ===============================
> Life is not fair, get used to it!
> God is fair, get Him!
> "William Ryan eMVP" <bill@NoSp4m.devbuzz.com> wrote in message
> news:uIhngar6DHA.2472@TK2MSFTNGP10.phx.gbl...
> > You are using a Reserved word (Password) so either replace it (and
> probably
> > username too to be safe) or wrap it in [ReservedWord] here. All in all,
> I'd
> > recommend getting rid of the reserved word all together b/c you or
someone
> > else may forget to do this in the future.
> >
> > HTH,
> >
> > Bill
> > "Oluwole Kolawole" <wole@k4plus.co.uk> wrote in message
> > news:ucYQoIr6DHA.3288@TK2MSFTNGP11.phx.gbl...
> > > Hi all,
> > >
> > > I need another set of eyes to look at a problem I'm having. I'm trying
> to
> > > insert data into a Micrsoft Access 2002 table using the following SQL
> > > statement (all fields are Text):
> > >
> > > "Insert Into Customers (UserName, Password, FirstName, LastName,
> Address,
> > > PostCode, PhoneDay, PhoneEve, PhoneMob) Values ('Jack', 'beanstalk',
> > 'Jack',
> > > 'Beanstalk', 'Nowhere', 'Nothing', '00000000', ' ', ' ')"
> > >
> > > As far as I can tell, there is absolutely nothing wrong with this
Insert
> > > statement but ADO.Net thinks different and I keep getting a "Syntax
> error
> > in
> > > INSERT INTO statement" error. The code I'm using is as follows:
> > >
> > > bool AllOk = true;
> > > RowsAffected = 0;
> > > try
> > > {
> > > OleDbConnection cn = new OleDbConnection(cnString());
> > > cn.Open();
> > > OleDbCommand cmd = new OleDbCommand(SQLstmt, cn);
> > > RowsAffected = cmd.ExecuteNonQuery(); <----THIS DOESN'T WORK
> > > cn.Close();
> > > cn.Dispose();
> > > cn = null;
> > > cmd.Dispose();
> > > cmd = null;
> > > }
> > > catch (Exception e)
> > > {AllOk = false;}
> > >
> > > I'm getting desperate, can anyone tell me what I'm doing wrong.
> > >
> > > Regards.
> > >
> > >
> > >
> > > Wole
> > > London.
> > > --
> > >
> > >
> > >
> > > ===============================
> > > Life is not fair, get used to it!
> > > God is fair, get Him!
> > >
> > >
> >
> >
>
>