Multiuser capabilities of MS Access running against Oracle database
What are the multiuser capabilities of MS Access running against an Oracle database?
MS Access has always been a single-user database, even though it has been designed to let multiple users open the Access database at the same time. MS Access has no transaction control so two users simultaneously modifying data can result in inconsistent transactions.
However, if you are using MS Access as a gateway to your Oracle database, then Oracle will handle the transaction control for the data in the Oracle database. Many people have successfully used MS Access as a front end to their Oracle database.
This was first published in November 2005