Re: Grid control/Access front/Oracle back

Don't worry. My fault.
Thanks again.
dm

Brendan Reynolds <brenreyn_at_indigo.ie> wrote in message news:sd8T6.5406$Fk7.42014_at_news.indigo.ie...
> 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 - 13:53:53 CDT