PC Review

Thread Tools Rate Thread

problems with odbc linked view

Posts: n/a
      10th Nov 2005

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.
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked View causing ODBC Call Failed DE Microsoft Access ADP SQL Server 1 6th Jul 2008 12:40 PM
ODBC driver shows in registry key but not under ODBC Administrator =?Utf-8?B?bG91XzE=?= Windows XP General 5 8th Dec 2005 09:27 PM
Linked Table Query Problems (SQL Server ODBC) =?Utf-8?B?dGtvc2Vs?= Microsoft Access Queries 4 16th Aug 2005 10:47 PM
UPDATE a linked access table with value from a ODBC linked SQL table JB Microsoft Access 0 18th Nov 2003 10:27 PM
MySQL ODBC Linked Table and View julie Microsoft Access External Data 1 22nd Oct 2003 06:28 AM




All times are GMT +1. The time now is 11:24 AM.