Multiuser capabilities of MS Access running against Oracle database

What are the multiuser capabilities of MS Access running against an Oracle database?

    Requires Free Membership to View

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.