Discussion Locked

Oracle and Access Best Practices

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm looking for best practices for developing an application using Microsoft Access 97 as a front end to an Oracle 8 database. How to efficiently call a stored procedure with a pass-thru query, etc. My experience is with SQL Server and Oracle is abit different. Sample code is best for me. Are there news groups devoted to this subject that you know of? I've tried the book store, MSDN, the Oracle web site, etc. but everything is targeted toward RDO or ADO and VB. This particular project requires Access97 and consequently the jet engine. I could use ADO on top of that if necessary, but would like to minimize the memory footprint and support concerns as much as possible by staying native with Access.

3 replies

by matthew.alverson

This depends on the applications size. Small less than 5 users then link the tables. Much more than 5 users and this can become a support nightmare. Is the Oracle database updated any other way, if not write somecode to import the table into access each night and then upload the changes the next night. If you are just reporting the data writing some code to import is the best solution. I no this does not help much but this has been my experience. Combining access and oracle can be quick development but it requires a lot of support. It is worth the extra effort to exclude access if the application will be around for a while.

This discussion is closed to new replies.