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

[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.

 

[Rick Brandt]

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 DB

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.

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.