Re: How does Access 97 rate as a front end?

Access does not behave in a scalable manner.

We've analyzed the sql activity it generates while a user browses the database and found that
(a) it tends to fetch every row of a table 1 row at a time (possibly ODBC default)
(b) it fetches only what is viewable, resulting in re-fetching activity as the user navigates the scroll bar.

(b) could be considered 'good' behvior if your result sets are large, and the user will not keep them up and constantly scroll back and forth.

those are the two most obvious issues.

--
--------------------------------------------
Marc Cooperman
Director of Technology
Teleran Technologies, L.P.
(973) 781-9699 x207
http://www.teleran.com
ramonherrera_at_hotmail.com wrote in message
<7569rk$ks6$1_at_nnrp1.dejanews.com>...


>My question is:

>

>How does Access 97 rate as a front end?

>

>My manager and I are exploring options regarding how we'll deal with an

 Oracle


>8 database.  We're looking to purchase and install the server in Q1 or Q2.

>Everybody here has Access 97.  Oracle says it supports ODBC.  Are there any

>pitfalls or headaches involved in querying an Oracle DB with Access?

>

>Any ideas or suggestion would be greatly appreciated.

>

>Thank you.

>

>-----------== Posted via Deja News, The Discussion Network ==----------

>http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own