Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: VB-Application: Changing Backend from Access to Ora
I probably don't want to know >>why<< you are doing this, but ADO is
probably the best solution to run with Oracle as far as a Microsoft data
access component goes.
The easiest as far as development would probably to create linked tables to an Oracle database through access and just access the tables through access.
Either way, it's not the best idea to have half of your application on oracle and half on access.
"David Schläpfer" <dsc_at_d-s-c.ch> wrote in message
news:ak3cq8$1fmf0h$1_at_ID-78819.news.dfncis.de...
> 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!!
>
>
>
>
Received on Thu Aug 22 2002 - 14:33:54 CDT