asked on

Reading oracle tables through Microsoft Access

Experts,

Does reading Oracle tables using Microsoft Access slow down resources?

SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

morinia

ASKER

Thanks experts for your feedback. A prior company I worked for did not allow access to the data warehouse or any of our major servers. We were told because Access as a resource hog and would slow down other access to the tables. I was just confirming since I thought that is what I remembered.

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

johnsone

Depends on what you are doing. If you are using the query builder in Access then yes. It generates absolutely horrid queries. Very poorly constructed and definitely contributed to extreme issues on the database side.

If you are doing pass thru queries, then it is like running any other query. Only as good as the person writing them.