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:
    428
    Charles
    Jul 2, 2003
  2. Guest
    Replies:
    1
    Views:
    635
    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:
    197
    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:
    136
    Guest
    Jul 19, 2006
  5. Crossh

    Access Date linked to SQL ODBC not working on Vista

    Crossh, Dec 29, 2008, in forum: Microsoft Access Form Coding
    Replies:
    1
    Views:
    196
    Crossh
    Jan 16, 2009
Loading...

Share This Page