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
Printable View
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
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
Is it possible to create your own indexes on a linked table?
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