[AccessD] ODBC-Problem (Cross-posted)

If you link directly to the view in Access, is it updateable?  If not, then it's the design of the view that is the problem.  There are SQL Server fields, like the datetime fields, that can't be edited directly from Access, and SQL Views are not necessarily updateable in Access.

Charlotte Foust

-----Original Message-----
From: Curtis, Andrew (WAPL) [mailto:andrew.curtis at wapl.com.au] 
Sent: Wednesday, May 21, 2003 11:53 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] ODBC-Problem (Cross-posted)


IN SQL Server help, lookup distinctrow or distinct I recal seeing siomething on this in there.

andrew

-----Original Message-----
From: Michael Brösdorf [mailto:michael.broesdorf at web.de] 
Sent: Monday, 19 May 2003 4:23 PM
To: accessd at databaseadvisors.com; dba-sqlserver at databaseadvisors.com
Subject: [AccessD] ODBC-Problem (Cross-posted)


Hi all,

I have a strange problem with my Access 2K app:

The app uses linked ODBC tables to connect to a SQL-Server 2000. One of the tables actually links a view that combines data from 2 tables. A data entry form is based on that linked table.

I can update data in all the fields with one exception: when I try to update data in fields that originate from both base tables I get this ODBC error:

"[Microsoft][ODBC SQL Server Driver][SQL Server]View of function 'dbo.myview' is not updateable because the modification affects multiple base tables. (#4405#)"

It does not make a difference if I try that in the data entry form or the linked table directly.

Now, the strange thing is, if I open the view on the server using the enterprise manager, I _can_ update fields from different base tables simultaneously.

Is there any way to 'convince' my app, that this kind of updates _is_ possible?



Michael

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


NOTICE - This message and any attached files may contain information that is confidential and/or subject of legal privilege 
intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering 
the message to the intended recipient, be advised that you have received this message in error and that any dissemination, 
copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein.  
If you have received this message in error please notify the sender immediately and delete the message

Worsley Alumina Pty Ltd ABN 58 008 905 155 is the manager of the Worsley Joint Venture - Bauxite/Alumina Operation. Liability and responsibility of the Joint Venturers is several in accordance with the following schedule of participating interests: Billiton Aluminium (RAA) Pty Ltd 56 percent, Billiton Aluminium (Worsley) Pty Ltd 30 percent, 
Kobe Alumina Associates (Australia) Pty Limited 10 percent, Nissho Iwai Alumina Pty Limited 4 percent.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com