Click to See Complete Forum and Search --> : oracle


freek
August 16th, 1999, 06:57 AM
I have created a database in Oracle and then linked the tables in Access.
The problem is, that the indexes I have created in Oracle doesn' t seem to work in Access.

Does anyone know something about this?

thanks

kieran_rush
August 19th, 1999, 05:27 PM
As far as I know you can't use Oracle indexes in another database, this indexes are only for Oracle, try creating Access own indexes
Regards
RSV

freek
August 20th, 1999, 02:33 AM
Is it possible to create your own indexes on a linked table?

kieran_rush
August 20th, 1999, 08:23 AM
Like I told you, as far as I know you can't create that kind of indexes, you must have your own indexes for each table, if you use the same database you can use the relationship feature for the tables, but can't have a same linked index for Oracle and Access