Ask the Expert

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: