Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: VB-Application: Changing Backend from Access to Ora

Re: VB-Application: Changing Backend from Access to Ora

From: Gareth Gibbings <garethg_at_gkgib.demon.co.uk>
Date: Fri, 23 Aug 2002 13:59:07 +0100
Message-ID: <7BEgzMnbGjZ9Ewz2@gkgib.demon.co.uk>


In article <ak3cq8$1fmf0h$1_at_ID-78819.news.dfncis.de>, David Schläpfer <dsc_at_d-s-c.ch> writes
>I have a VB-Frontend (also handling referencial integrities). Running on
>several clients.
>then there is a server with ms-access, only tables, no logic, no references.
>
>I want to be able to support **also** Ora-Tables on the server. (in some
>cases there will be still MS-Access).
>
>What is the best way to change the application, so that further development
>is **easy**, supporting both ORA and Access.
>
>RDO? or better DAO? Do I need to install a datasource manually (system-
>'data sources'), or can this be handled automatically?
>
>Thanks for Your support!!
>
>
>
>

I would suggest ADO and Oracle Views rather than tables.

-- 
Gareth Gibbings More Input Limited
Received on Fri Aug 23 2002 - 07:59:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US