Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Unanswered: Problem in updating SQL backend via Excel VBA

    Dear all,
    I have create an Excel application which connects to an SQL Server backend.
    I have written an Excel vba procedure to update a table via ADO.
    But it couldn't---the error message says the provider (sqloledb) does not support updating database.

    Does anybody know how can I fix this ?
    Thank you very much in advance.

    Lepanto

  2. #2
    Join Date
    Jan 2014
    Posts
    5
    Colud be a coding error when you connect/open database and/or Recordset.
    Show the complete code you use to open ADODB.Connection and open the ADODB.Recordset.

  3. #3
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    Another angle - you may want to consider doing the updates using sp's in sql instead of opening recordsets. It's very clean on both ends and far less prone to problems. let us know if you have questions or want details.
    have fun!

    Todd S.
    click to email


    Independent Development Consultant
    Biz db & reports - SQL, Access, Crystal, Seradex and more
    Small, custom, unique programs - Office, VBA, .NET


    _________________________________________________
    Favorite message from Windows:
    There was an error displaying the previous error message

    Sadly, there was no error number to look up ...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •