Discussion Locked

MS-Access FrontEnd Oracle 10g BackEnd

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can anyone tell me the advantages and disadvantages of a Oracle 10g back-end with a MS-Access 97/2003 client front-end versus a web-based front end to the Oracle 10g back-end? Also, can anyone give me information on the advantages/disadvantages of using Oracle 10g replication vs a web-based front-end? Thanks!

2 replies

by nz_justice

I can tell you access front ends are the worst. There is no advantages to access front end unless it only envolves an access database. Build your own front ends. Go for the web front-end solution.

by llkhoutx

I support about 350 MDB front-ends with Oracle 9 back-ends. The advantage is that Oracle tables with millions of rows and various joins run/execute quickly on the Oracle server, not by Jet or in Access. Some Oracle tables won't fit in an Access 2GB mdb. Small Oracle tables join and run well with native Access tables in queries. However, large Oracle tables joined with native Access tables just flat won't run; no room, as all Oracle records have to be loaded into Access.

This discussion is closed to new replies.