Home › Products › Comparing DataEase 7.1 and Microsoft Access 2003
Comparing DataEase 7.1 and Microsoft Access 2003
Use the table below to compare DataEase 7.1 with Microsoft Access 2003 and decide which database best fits your needs.
| Criteria | DataEase 7.1 | Microsoft Access |
| Getting Started | No previous database knowledge required Use the 10 bundled application to see the possibilities of dataease for you. These can help you get started in a matter of minutes. |
Requires database expertise Theoretical database knowledge is essential prior to constructing an application. |
| Ease of Use | No Table creations necessary Create and amend any part of the application at any stage. |
Manual Creation Table creation is important, finding data requires mastering SQL. |
| Scripting and programming | Point & click field rules Use the simple DQL to write scripts in Dataease, there is no need to learn complex programming as DQL is a simple scripting tool. |
Programming knowledge required Although 56 macros cover basic tasks, but some database functions require Visual Basic knowledge. |
| Customisation | Handy customisation tools Customise you application using the simple tools embedded in dataease. |
High-level customisation Extensive customisation requires knowledge of Visual Basic. |
| Reporting | Multiple reporting outputs Export your data in PDF, HTML, RTF and Excel, as well as report it using traditional reporting tools. QBM "Query by model", QBF "Query by form". |
Manual Design Interface Wizards help in making reports but modifications requires going through advanced design interface. No PDF output is available. |
| Database capacity | 400 Terabytes capacity Each field being capable of holding 2GB of data. |
2 gigabyte capacity 2GB limit per database, text fields hold 255 characters, memo fields hold 65,535 characters. |
| Scalability | Supports large work groups 1000 users to use the application with up to 255 concurrent users. |
Supports small workgroups No access server available, thus performance may reduce when more than 20 users concurrently use the database. Note: Sharing of Access solution is possible with SQL server, but need to re-write the application. Source: MSDN Library |
| Web Publisher | Share complete application via web The complete application can be published online and used by unlimited users online. |
Component Share only You can share individual forms and reports online but not the entire database application. |
| Security | Database and Field level access controls Allows restricted access to the database and fields within the database. |
Database level access Allows restricted access to the database only. |
| Platform | Windows | Windows |
| Connectivity | OLE DB | SQL Server Enhanced performance using extension into SQL server. |
