Advantages of MS Access
MS Access is a light weight database managements system. Also, it provides it's own designer so that you can generate reports and simple windows applications without using another programming environment.
It is easy to deploy an MS Access database. Just copy the .MDB file to appropriate location and you are done. There is no database attach/detach process.
Which one to choose - MS Access or SQL Server ?
MS Access is ideal only for applications that require very small databases. Even though the maximum database size limit for MS Access is 1 GB, the performance becomes poor if the size grows more than few hundred MBs.
If you expect your application database to grow more than 100 MB in future, you should consider using SQL Server. It may not be an easy task to migrate to SQL Server later. Eeven though SQL Server allow you to import your MS Access database to SQL Server, you will have to do lot of code changes to take advantage of the SQL Server features.
There will be major performance difference between MS Access and SQL Server. If you are writing a critical application where performance is important, then you must consider SQL Server instead of MS Access.
The new SQL Server 2005 Express is a free version and allow copy/deploy feature. You can copy the database file and attach on the fly. It is a good idea to use SQL Server 2005 Express if you cannot afford to purchase SQL Server license. It has much better peformance and features compared to MS Access.
The bottom line is, choose MS Access only for small and non critical applications.
Popular Posts
-
Now I will show you how to retrieve the data posted from a HTML file in a JSP page. Consider an html page that prompts the user to enter his...
-
Accessing the Standard CGI Variables: To build the successful web application, you often need to know a lot about the environment in which ...
-
INTRODUCTION TO 'C': C is a programming language developed at AT & T's Bell laboratories of USA in 1972.it was designed by d...
-
SQL aliases can be used with database tables and with database table columns, depending on task you are performing. SQL column aliases are u...
-
Learning about Events (Continue) Lets program the Form_Load event. "MsgBox" is Visual Basic command that launch a message box. for...
-
Steps to follow: 1. Write Person.java as shown below in Code-11.3.a under polypackage directory. (You are welcome to do this work using eit...
-
The Command Button's KeyPress, KeyDown and KeyUp Events The events that will be mentioned in the following pages are commonly used, and ...
-
The SQL AVG aggregate function selects the average value for certain table column. Have a look at the SQL AVG syntax: SELECT AVG(Column1) FR...
-
package interfaceexercise; // Define an interface with three abstract methods. // Any class that implements this interface has to // impleme...
-
We will use the Customers table to illustrate the SQL LIKE clause usage: FirstName LastName Email DOB Phone John Smith John.Smith@yaho...
No comments:
Post a Comment