You could import the tables from Oracle to MS Access using ODBC but the relationships will not go with it and the data types will not be exactly the same.
: : : I currently have a system using Oracle database. Is it possible or are there anyways to convert the Oracle database into MS access database (as in all the structure or if possible all the data also of the tables remain the same). Please advise. Thank you.
: : :
: :
: : The reason why I need to convert the Oracle database is that currently the system is connected to a server with Oracle. I wanted to make it so call standalone (remote) where my system can run on the terminal it is install in, with the database in the terminal also. It is not feasible to install Oracle into evey of the standalone terminals so the only way out might be changing the database instead. Any advice on this issue? Thanks alot.
:
: An Oracle database doesn't need to be on every machine that accesses it. We have a single database on a UNIX server that is accessed by a cluster of Win2000 Terminal Servers as well as our development machines. Well, I suppose if you don't have any network at all then you're out of luck there too.
:
: About the best you could hope for is to extract the DDL statements for your tables and other structures and try to execute them in Access, but I'm guessing it's not going to work very well. Maybe you'll get lucky, though.
:
:
:
infidel
:
:
: $ select * from users where clue > 0
: no rows returned
:
:
:
