Q

Multiuser capabilities of MS Access running against Oracle database

What are the multiuser capabilities of MS Access running against an 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

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close