Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Slow ODBC Connection from MS Access 2000

491197Feb 15 2006 — edited Feb 23 2006

I currently have an MS Access 2000 application that I would like to connect to an Oracle 9i backend. I noticed that the performance of the linked Oracle tables are slower. I discovered it was because of the subdatasheetname property set as [Auto] on the linked Oracle table. However, because these are linked Oracle tables, I am unable to change the subdatasheetname property from MS Access. Is there any way to change this setting in Oracle?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 23 2006

Added on Feb 15 2006

#general-database-discussions

9 comments

994 views