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: Linking Access tables from Oracle

Re: Linking Access tables from Oracle

From: Frank Bauer <info_at_office-tech.de>
Date: Wed, 7 Jul 1999 07:21:50 +0200
Message-ID: <7luo3s$k22$1@news00.btx.dtag.de>

> The problem is, the table DOES exist.....they were imported from an
> existing Access Database to Oracle.
> Plus, when doing a describe in Oracle, the table is there.
>
> Any suggestions as to why this would work?
>
> Thanks
>

did you migrate your access application with the ACC2Oracle-Tool? IF this so, and your access application was a frontend/backend configuration, then the migration tool, sets up two user (frontend_username, backend_username) and moves the tables to the backend_username. You can see the tables from the frontend_username (usually used in the odbc connections) but cant get it into access again.
we solved this problem at this way:
- delete tables from backend_username
- use the sql-skripts in Access2Oracle Tool-directory (ctable.sql, crel.sql and so on) to create the tables new in the frontend_username - moves data from old access to the new created tables on oracle

This way we solved this problem here. May be it helps you too.

Frank Received on Wed Jul 07 1999 - 00:21:50 CDT

Original text of this message

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