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 kadvani
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.
by kadvani
by kadvani
This discussion is closed to new replies.
Trending Networks posts
Sort by Trending