OleDb update command not being reflected in Access database

I am trying to issue an update command from OleDb, but when I issue
the command and see how many rows were effected, it always returns 0.
If I issue the exact same command, on the same database, from the
Access SQL query window, the update works as desired. All of my
insert, deletes and selects from OleDb work perfectly. Does anyone
have any thoughts? Thanks.
.

Relevant Pages

  • Re: VFP Updates?
    ... Try talking ODBC or OleDb and they say HU. ... make up my apps so that what ever they want to run has to be from a command ... kind of connection and assign it the right to do exactly what you want. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: OLEDB Newbie - how to ignore deleted rows?
    ... Try sending the command "SET DELETED ON" through VFPOledb ... > I've attached six screen shots which are the dialog and properties ... I create a task moving data from FoxPro to SQL, ... > I can change the type of command I execute on the OLEDB source to be ...
    (microsoft.public.fox.vfp.dbc)
  • Re: TADOQuery slow inserts in Oracle
    ... try to use another OLEDB ... provider. ... >> Or, even better, use prepared ADO command with parameters. ... > INSERT command, and that kept the Parameters from filling in). ...
    (borland.public.delphi.database.ado)
  • Re: Replacing stored procedure
    ... you just use a Paramaterized sql statement (in ... So you'll have an insert command, ... Have an opinion on the effectiveness of Microsoft Embedded newsgroups? ... > in access using oledb & vb.net? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: oledb date/time insert command format
    ... I'm still receiving a syntax error in "insert into" command ... I never used Access and Oledb, ... > Microsoft Access 2000 ...
    (microsoft.public.dotnet.languages.vc)