| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: MS Access migration to oracle
Check the ODBC configuration in Control Panel and make sure the connection
is not set to read only. If you have primary keys on the tables access
should be capable of seeing these and thus will allow updates to the table.
If not you should be prompted to supply the key columns from a list of
columns when you attach to the table. Other than that I would suggest you
update the ODBC drivers.
-----Original Message-----
Sent: Thursday, February 28, 2002 7: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).
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 - 11:48:25 CST
 |
 |