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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: MS Access migration to oracle

RE: MS Access migration to oracle

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Thu, 28 Feb 2002 06:48:21 -0800
Message-ID: <F001.0041B05B.20020228064821@fatcity.com>


Either it's the privileges on the tables or the tables do not have primary keys or unique keys.

Access will put the table in read only mode if it does not have PK or Unique key.

Waleed

-----Original Message-----
Sent: Thursday, February 28, 2002 8:13 AM To: Multiple recipients of list ORACLE-L

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: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.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). Received on Thu Feb 28 2002 - 08:48:21 CST

Original text of this message

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