Hi

I am using the Ados and I have database Oracle. What I want is, All the relations , tables ie entire schema to be ported to Access database.

I tried using Access 97 import, but i am able to get only the data along with table definitions. But there were no relations. I set the relations for about 250 tables manually.

In Oracle , I have some tables related with referential integrity forced that is CASCADE on DELETE is there. But when I tried to set the same for in the Access 97., it says, no unique index. When I tried to create index, it did not allow me, telling uniqueness is violated.

I am totally confused and depressed, so trying to get the help,

Hope you understood the problem.

Thanks in advance,
Satya




"If you like any thing very much, let it go for free.
If it does not return to you, it is never meant for you,
if it does cherish it forever. "


With Warm Regards
Satya
Personal Email : s_p_vedula@geocities.com
Personal Fax : (603) 688-2585
Personal Home : http://prakash.virtualave.net