Re: In MS access: How to alter data in attached Oracle table ??
From: J,M.Whitehead <j.m.whitehead_at_shef.ac.uk>
Date: 1996/04/17
Message-ID: <4l2k5p$67b_at_bignews.shef.ac.uk>#1/1
Date: 1996/04/17
Message-ID: <4l2k5p$67b_at_bignews.shef.ac.uk>#1/1
In article <316D1EE7.4253_at_cho.ge.com>, chris.little_at_cho.ge.com says...
>I can't delete rows of data in the
>table, however. The oracle owner can do all this in sqlplus, but
>not in Access. Is there a setting in Access I need to adjust.
To do any alteration of attached tables via Access and ODBC you must make sure that each of the attached tables has a unique index on it. This is documented somewhere either in access help or odbc help.
HTH. Jon.
-- Jonathan M. Whitehead | j.m.whitehead_at_sheffield.ac.uk Dept. Of Corporate Information | University Of Sheffield | Firth Court | Western Bank | Sheffield |Received on Wed Apr 17 1996 - 00:00:00 CEST