|
 |
activex_data_objects thread: Error Inserting or Updating
Message #1 by "Tony Pacetti" <one_dev@h...> on Wed, 23 May 2001 10:26:34 -0500
|
|
Hello Everyone,
I'm receiving the error "Operation must use an updateable query" when trying
to Update or Insert into an Access Database using ADO and OLE DB.
Set cnn = New ADODB.Connection
cnn.Mode = adModeReadWrite
cnn.Open getCnnStr()
cnn.Execute sSQL
cnn.Close
Set cnn = Nothing
The error only occurs after distributing the application to other machines,
not on my development PC.
I did notice something strange. Access (or ADO) is NOT creating the .ldb
file in the Database file directory like it normally does.
Thanks in advance for your help.
Message #2 by "Wally Burfine" <oopconsultant@h...> on Wed, 23 May 2001 15:45:01 -0000
|
|
Check the properties of the MDB to make sure that it is not Read-Only. Also
check the folder properties to make sure that the iusr has write permissions
to the folder.
Regards,
Wally
>From: "Tony Pacetti" <one_dev@h...>
>Reply-To: "ActiveX_Data_Objects" <activex_data_objects@p...>
>To: "ActiveX_Data_Objects" <activex_data_objects@p...>
>Subject: [activex_data_objects] Error Inserting or Updating
>Date: Wed, 23 May 2001 10:26:34 -0500
>
>Hello Everyone,
>
>I'm receiving the error "Operation must use an updateable query" when
>trying
>to Update or Insert into an Access Database using ADO and OLE DB.
>
> Set cnn = New ADODB.Connection
> cnn.Mode = adModeReadWrite
> cnn.Open getCnnStr()
> cnn.Execute sSQL
> cnn.Close
> Set cnn = Nothing
>
>The error only occurs after distributing the application to other machines,
>not on my development PC.
>
>I did notice something strange. Access (or ADO) is NOT creating the .ldb
>file in the Database file directory like it normally does.
>
>Thanks in advance for your help.
>
Message #3 by "Tony Pacetti" <one_dev@h...> on Wed, 23 May 2001 12:26:33 -0500
|
|
Thank You Wally, you were right. When I distributed the MDB on a CD-ROM it
was changed to Read-Only.
Thanks a lot!!!
"Wally Burfine" <oopconsultant@h...> wrote in message
news:67956@a..._data_objects...
>
> Check the properties of the MDB to make sure that it is not Read-Only.
Also
> check the folder properties to make sure that the iusr has write
permissions
> to the folder.
>
> Regards,
> Wally
>
>
> >From: "Tony Pacetti" <one_dev@h...>
> >Reply-To: "ActiveX_Data_Objects" <activex_data_objects@p...>
> >To: "ActiveX_Data_Objects" <activex_data_objects@p...>
> >Subject: [activex_data_objects] Error Inserting or Updating
> >Date: Wed, 23 May 2001 10:26:34 -0500
> >
> >Hello Everyone,
> >
> >I'm receiving the error "Operation must use an updateable query" when
> >trying
> >to Update or Insert into an Access Database using ADO and OLE DB.
> >
> > Set cnn = New ADODB.Connection
> > cnn.Mode = adModeReadWrite
> > cnn.Open getCnnStr()
> > cnn.Execute sSQL
> > cnn.Close
> > Set cnn = Nothing
> >
> >The error only occurs after distributing the application to other
machines,
> >not on my development PC.
> >
> >I did notice something strange. Access (or ADO) is NOT creating the .ldb
> >file in the Database file directory like it normally does.
> >
> >Thanks in advance for your help.
> >
>
>
Message #4 by "Wally Burfine" <oopconsultant@h...> on Wed, 23 May 2001 18:35:33 -0000
|
|
Tony,
That's one of those "been there done that" kind of things. Like not having
the computer plugged in. When things look like you can't write to them it
has to be a permissions problem.
I'm glad I could be the Hero this time. Next time I will need your help.
Regards,
Wally
>From: "Tony Pacetti" <one_dev@h...>
>Reply-To: "ActiveX_Data_Objects" <activex_data_objects@p...>
>To: "ActiveX_Data_Objects" <activex_data_objects@p...>
>Subject: [activex_data_objects] Re: Error Inserting or Updating
>Date: Wed, 23 May 2001 12:26:33 -0500
>
>Thank You Wally, you were right. When I distributed the MDB on a CD-ROM it
>was changed to Read-Only.
>
>Thanks a lot!!!
>
>"Wally Burfine" <oopconsultant@h...> wrote in message
>news:67956@a..._data_objects...
> >
> > Check the properties of the MDB to make sure that it is not Read-Only.
>Also
> > check the folder properties to make sure that the iusr has write
>permissions
> > to the folder.
> >
> > Regards,
> > Wally
> >
> >
> > >From: "Tony Pacetti" <one_dev@h...>
> > >Reply-To: "ActiveX_Data_Objects" <activex_data_objects@p...>
> > >To: "ActiveX_Data_Objects" <activex_data_objects@p...>
> > >Subject: [activex_data_objects] Error Inserting or Updating
> > >Date: Wed, 23 May 2001 10:26:34 -0500
> > >
> > >Hello Everyone,
> > >
> > >I'm receiving the error "Operation must use an updateable query" when
> > >trying
> > >to Update or Insert into an Access Database using ADO and OLE DB.
> > >
> > > Set cnn = New ADODB.Connection
> > > cnn.Mode = adModeReadWrite
> > > cnn.Open getCnnStr()
> > > cnn.Execute sSQL
> > > cnn.Close
> > > Set cnn = Nothing
> > >
> > >The error only occurs after distributing the application to other
>machines,
> > >not on my development PC.
> > >
> > >I did notice something strange. Access (or ADO) is NOT creating the
>.ldb
> > >file in the Database file directory like it normally does.
> > >
> > >Thanks in advance for your help.
|
|
|
View Cart
