MSAccess as Front End (What version should I use?)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I'm working with +/- 300 Gb Oracle database and keep growing
I'm use Access 97 as a front end interface for end user and will migrate to higher version of Access, actually there is no problem with this application, everybody happy with their rapid dev. capability, interoperability with other office application, intuitive charting capability and crosstab query features

Can anybody suggest me what version of access I should choose
What version will give me the best performance and reliability
Still it acceptable using access to handle those kind size of back end D

I'm using ODBC link connection for consult our back end DB and for performance reason also using temporary table in the access native table.
 
Gabriel said:
Hi,
I'm working with +/- 300 Gb Oracle database and keep growing.
I'm use Access 97 as a front end interface for end user and will migrate
Click to expand...
to higher version of Access, actually there is no problem with this
application, everybody happy with their rapid dev. capability,
interoperability with other office application, intuitive charting
capability and crosstab query features.
Can anybody suggest me what version of access I should choose ?
What version will give me the best performance and reliability ?
Still it acceptable using access to handle those kind size of back end DB

I'm using ODBC link connection for consult our back end DB and for
Click to expand...
performance reason also using temporary table in the access native table.

Properly implemented, an Access front end has no issues concerning how
large the back end is. It will handle whatever the back end can handle,
which in the case of Oracle is considerable. You can certainly design the
front end poorly so that performance is terrible, but you can do that with
any front end tool.

As for the version I wouldn't change unless you read the various "What's
New?" articles on MS web site for the newer versions and see something that
looks appealing. There is nothing about the newer versions that would
impact performance in a positive way.
 
Back
Top