access with oracle database

[chirpyform]

We are trying to link an access database to an oracle database whilst keeping the access code and forms the same.
In fact we want to recreate the same tables in oracle and map them using the linking tables option.
Does this work ?
What are the impacts in the code, the forms, queries, etc. ?

Any help would be gratefully received


Chris

 

[dhookom]

This should work but might not be overly efficient. If you don't need to edit data (reports and some forms), you are much better off retrieving the data with a pass-through query. Also, there may be some code that is specific to access tables.

If you intend to edit records, you must have a primary key identified in the Oracle tables.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[willir]

Look up "pass through queries" as referenced by Duane, and "stored procedures". I suspect working as much as possible with SQL instead of code may be best. If applicable, take advantage of triggers on the Oracle database.