Discussion Locked

comparison between ms-access n database

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
what is similerty and difference between ms-access and aql server, db2,abd oracle

2 replies

by viplav76

MS-Access is a simple RDBMS database, part of the Office suite, whereas the others are large systems capable of supporting complex database systems.

by wayne m.

MS Access is a single user, desktop database that supports a basic subset of standard SQL commands.

Its primary advantage is that it supports an integrated UI development environment for queries, reports, and graphs. One can direct the user interface to another database over ODBC connections allow use of SQL Server, Oracle, etc.

As noted above, it comes as part of MS Office, so no additional software purchases or licenses are required.

MS Access fills the need between a spreadsheet and a client-server or n-tier database application.

This discussion is closed to new replies.