Sorry, David, I misunderstood your question. I'm afraid I can't help with
that, although I do wonder whether using ADO and the OLEDB provider for
Oracle might work for you? Anyone out there with experience of using Access
with Oracle care to comment on that?
--
Brendan Reynolds
brenreyn_at_indigo.ie
http://www11.ewebcity.com/brenreyn
"David Moss" <dm_at_buscon.demon.co.uk> wrote in message
news:991744798.27565.0.nnrp-08.c2deb590_at_news.demon.co.uk...
> Thank you for your very quick response.
> I can, indeed, link the Access front-end to Oracle back-end tables using
> ODBC
> as long as I'm prepared to define the primary key again
> and then base updatable queries and forms on those linked tables.
> But I am trying not to use ODBC.
> I am after a grid control that I can connect directly to the back-end
tables
> with OO4O
> or which can use the OraDC control as its source.
>
> Brendan Reynolds <brenreyn_at_indigo.ie> wrote in message
> news:oFTS6.5206$Fk7.40382_at_news.indigo.ie...
> > Access doesn't need any additional controls to display or edit multiple
> > records - that facility is built in. You can use a form in datasheet or
> > continuous forms view, either stand-alone or as a subform within a main
> > form.
> >
> > --
> > Brendan Reynolds
> > brenreyn_at_indigo.ie
> > http://www11.ewebcity.com/brenreyn
> >
> > "David Moss" <dm_at_buscon.demon.co.uk> wrote in message
> > news:991686271.25071.0.nnrp-12.c2deb590_at_news.demon.co.uk...
> > > I am converting an Access 97 application to use Oracle 8i on the back
end.
> > > Oracle provide OO4O to connect VB to Oracle.
> > > VB has a dbGrid control to allow the user to edit data.
> > > No dbGrid in Access.
> > > Anybody know a control that would allow an Access user to display and
edit
> > > data from multiple rows?
> > >
> > > TIA
> > >
> > >
> >
> >
>
>
Received on Tue Jun 05 2001 - 11:53:44 CDT
