I have a Access(2003) DB with linked tables to a Oracle 10g DB thru a ODBC connection. There are no indexes built on the Access side but the Oracle Db has all the appropriate indexes on it. All the Access is used for is queries to the Oracle Db and users build these queries in access.
I just learned how to spell Access and was given this to admin.. While building a test 2007 Access Db I linked a table and Access asked for me to setup a Primary key. But the Oracle table has all of these already.
That got me looking around the forum for this and then I found Threads refering to ACCESS INDEXES built on linked ODBC Oracle tables.
When they set this Access Db up did someone miss the boat on setting primary keys in Access and indexes on the linked Oracle tables?
The queries run, although some do timeout. I just blamed it on the Access and ODBC connections not being robust enough to handle large returns.
Thanks
I just learned how to spell Access and was given this to admin.. While building a test 2007 Access Db I linked a table and Access asked for me to setup a Primary key. But the Oracle table has all of these already.
That got me looking around the forum for this and then I found Threads refering to ACCESS INDEXES built on linked ODBC Oracle tables.
When they set this Access Db up did someone miss the boat on setting primary keys in Access and indexes on the linked Oracle tables?
The queries run, although some do timeout. I just blamed it on the Access and ODBC connections not being robust enough to handle large returns.
Thanks