Paradox/Oracle Problem - Please Help!

[Linda]

Is there anyone out there that can help with this one?

I created a one-to-many purchase table with Oracle 8 as the back end, and
Paradox 9 as the front end. The connection choice used from Paradox to
Oracle is the "Microsoft ODBC for Oracle" driver provided by the BDE
Administrator/SQL Links package.

All the forms seem to be working properly under my own sign-on and password,
as well as other sign-ons and passwords, except for one problem: Paradox
does not recognize the indexes in the any of the forms that contain
one-to-many relationships when I test the application under a different
user's name and password (other than the creator's sign-on and password).
(Tried so far: Oracle side - grant all, creating indexes, using public
synonyms for all tables and indexes. Paradox side - index, reindex,
reindexall, and setindex commands.)

The weird thing is I tried using the Oracle driver on the Paradox side (BDE
Administrator/SQL Links) - and the indexes are recognized! But this form, as
well as all the other forms I've created where there aren't one-to-many
relationships, work as slow as mud. Some choice.

Has anyone else experienced this problem and discovered a solution? Any
help working out this problem would be greatly appreciated.

Thank you.