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...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
control for the data in the Oracle database. Many people have successfully used MS Access as a front end to their Oracle database.