problems with odbc linked view

Discussion in 'Microsoft Access Form Coding' started by Jason, Nov 10, 2005.

  1. Jason

    Jason Guest

    Hello,

    I've a problem with inserting a record through a form in Access. The
    recordsource is a view from sql server.

    The view has a computed column. The problem occurs when there is an
    insert/update on that view. The errors indicates that arithabort needs
    to be set on, etc.

    In my ado-connection i can fix that, but how do i do it when the view is
    linked through odbc? Maybe a 'instead of trigger'would do it, but i
    don't know how.
     
    Jason, Nov 10, 2005
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Charles
    Replies:
    0
    Views:
    488
    Charles
    Jul 2, 2003
  2. Guest
    Replies:
    1
    Views:
    777
    Ron Weiner
    Feb 19, 2004
  3. Rich

    Access Form Null Checking with Linked SQL / ODBC Table

    Rich, Oct 4, 2004, in forum: Microsoft Access Form Coding
    Replies:
    4
    Views:
    287
    Albert D. Kallal
    Oct 4, 2004
  4. Guest

    Updating a linked ODBC table from another tables form code

    Guest, Jul 19, 2006, in forum: Microsoft Access Form Coding
    Replies:
    0
    Views:
    158
    Guest
    Jul 19, 2006
  5. Guest

    Locking when linked to an SQL view.

    Guest, Aug 17, 2007, in forum: Microsoft Access Form Coding
    Replies:
    0
    Views:
    131
    Guest
    Aug 17, 2007
  6. Crossh

    Access Date linked to SQL ODBC not working on Vista

    Crossh, Dec 29, 2008, in forum: Microsoft Access Form Coding
    Replies:
    1
    Views:
    251
    Crossh
    Jan 16, 2009
  7. Barry A&P

    Help calculating totals from linked table in datasheet view

    Barry A&P, Feb 27, 2009, in forum: Microsoft Access Form Coding
    Replies:
    2
    Views:
    245
    Barry A&P
    Feb 28, 2009
  8. ODBC Update on a linked table 'table name' failed

    , Jun 29, 2010, in forum: Microsoft Access Form Coding
    Replies:
    1
    Views:
    1,006
    Tom van Stiphout
    Jun 30, 2010
Loading...