Re: MS Access migration to oracle

If VB code was connecting to Access db through ODBC datasource, just modify this this datasource (or delete/create new one with the same name) to use Oracle ODBC driver (instead of ACCESS ODBC driver) and point them to the entry in tnsnames, which you create for them to use. Still, probably they will have to make some modifications in their code, when connecting to the db, to provide logon/password information. I don't think it's possible to specify password, when configuring ODBC datasource.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, February 28, 2002 8:13 AM

> I've been told to migrate one MS-Access 97 database to oracle. Oracle
> Migration Workbench did the
> trick in an extremely clean, quick and complete way. Tables are created,
> populated with data and it is
> now when the problem starts. The people that were using this Access
> database were doing so by means
> of an ancient VB piece of ... code and they don't want or they don't know
to
> adjust it. They expect the program
> to somehow find the new Oracle 8.1.7.3 instance and continue to work as
it
> did before. I created a new access database
> containing ODBC links to the Oracle tables, but the program is complaining
> that the "links" are read only. Is there any way
> in this world or beyond to make these tables writable? I'm inclined to
tell
> them that they should do some coding, which is
> very likely to make them go back to Access.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gogala, Mladen
> INET: MGogala_at_oxhp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).