Discussion Locked

Pros and Cons for MS Access and Oracle

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to do a comparitive study of pros and cons of using MS Access over Oracle?. Where can i get this information ?.

5 replies

by roc180

You are really comparing night and day. Usually when you talk about Oracle you compare it to SQL Server. Access is much more a departmental database with few concurrent users and small data sets, where as Oracle is a enterprise database capable ofhandling many concurrent users and large data sets. For those reasons Oracle also carries a heavy price tag compared to Access. For more info you can go to Microsoft.com.

Good Luck

Neal Martinelli

by crgray

I agree with the first poster. SQL server would be the appropriate comparison for an Oracle database: even Oracle lite.

I am a manager in support of an Oracle Financials Application distributed world-wide, yet use many VB-Access applications.
Simple guidlines:
Distributed Applications w/
Millions of Records 100'-1000's of users
Solution Oracle or Sql Server

1000's of records dozens of users
Solution Access

Both Databases can be developed using Client/Server or Web front end.
If the application is a medium size and development time is an issue then I think an Access back end can be a quick solution.

If money;licensing;time & materials are not an issue and the project is fairly large.

If you go Oracle be prepared for technical support that is less adequate than what you might be used to from Microsoft.

If you need high end performance on a large distributed application then you have little choice; Oracle is the premier product.

This discussion is closed to new replies.