Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Linking Access tables from Oracle
> 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