22-05-2012, 12:49 PM
VB.NET
Advantages of VB.NET
• First of all, VB.NET provides managed code execution that runs under the Common Language Runtime (CLR), resulting in robust, stable and secure applications. All features of the .NET framework are readily available in VB.NET.
• VB.NET is totally object oriented. This is a major addition that VB6 and other earlier releases didn't have.
• The .NET framework comes with ADO.NET, which follows the disconnected paradigm, i.e. once the required records are fetched the connection no longer exists. It also retrieves the records that are expected to be accessed in the immediate future. This enhances Scalability of the application to a great extent.
• VB.NET uses XML to transfer data between the various layers in the DNA Architecture i.e. data are passed as simple text strings.
• Error handling has changed in VB.NET. A new Try-Catch-Finally block has been introduced to handle errors and exceptions as a unit, allowing appropriate action to be taken at the place the error occurred thus discouraging the use of ON ERROR GOTO statement. This again credits to the maintainability of the code.
• Another great feature added to VB.NET is free threading against the VB single-threaded apartment feature. In many situations developers need spawning of a new thread to run as a background process and increase the usability of the application. VB.NET allows developers to spawn threads wherever they feel like, hence giving freedom and better control on the application.
• Security has become more robust in VB.NET. In addition to the role-based security in VB6, VB.NET comes with a new security model, Code Access security. This security controls on what the code can access. For example you can set the security to a component such that the component cannot access the database. This type of security is important because it allows building components that can be trusted to various degrees.
• The CLR takes care of garbage collection i.e. the CLR releases resources as soon as an object is no more in use. This relieves the developer from thinking of ways to manage memory. CLR does this for them
Advantages of Microsoft Access 2007
• Microsoft Access is a relational database management system that is part of the Microsoft Office professional suite. The software combines the Microsoft Jet Database Engine with a graphical user interface and development tools. It can also import data in other Access databases including Excel, SharePoint, XML, Outlook, HMTL and many other types of data.
Data Access
• One of the key advantages to Access is the sheer amount of sources of data it can comprehend from any source. Importing and exporting data of many formats is key to the advantages of Access. It has the ability to link the data in its existing location for viewing, querying, editing and reporting. This allows the data to be changed and enables anyone with the Access platform to use the latest edits.
Jet Database Format
• Access can use the Jet Database format, which allows the application and data in one file to be easily distributed to other users who can run it elsewhere. Jet allows multiple users to access data concurrently and employs a data-locking policy when multiple users try to write the same data. Starting with Access 2007, there is an Office-specific version of Jet that is fully backward compatible with older files.
SQL Compatibility
• Another major benefit of Microsoft Access is its compatibility with SQL. From a programmer's perspective, this gives the software more utility to edit SQL statements and use them directly in macros or VBA Modules. This allows the data being used in Access to be view graphically or edited in the form of SQL statements, making it easier to manipulate Access tables.