MS Access and VB

MS Access and VB

• Salvador Cadena

  Hi There........ In the end you are going to have to make your own decision on a Database or data storage format to use .... It is a decision I recently made.....I believe a decision should be made on Quality and Best Fit and Ease of use not on Resource Usage or Minimal Fit.... I am speaking of a New Application not adding on to or maintaining an Existing Application.....To me it comes down to Access or SQL Server Express..... What I did was develop degenerate apps one using Server Express and the other with Access.... Once you do this you will see the strengths and weakness’ of both...... You also will learn how to use the IDE to do all the dirty work for you... One of the first Hurdles I hit with Access is that in order to generate databases EASILY you must buy Access....... You can download Northwind(which I did) for testing purposes..... Nothing against Access but for this and many other reasons SQL Server Express is a much better fit for VBE.... One major plus for Access is that the package I assume comes with a Report Writer..... SQL Server Wins Hands Down for me and I will use it Exclusively in any Application I ever Write.... Cheers

  
  

• hpux

  hi,

  i have a question and comment

  Question : - i saw many times ppl use (front end and back end) <<< what does that mean and forgive me because i'm not english speaker

  Comment :- Data storage is the file you use to store your data that depend on your need you can use txt, doc, xls, xml,mdb, or mdf or even others depending on your need simple data storage , or complecated one all that are valid solution and you are the one who determine which one fit your needs and which one you can use better

  best regards

  
  
  

• Mohammed Mudassir Azeemi

  if you are looking for a single user database, then Jet is a viable option. Access is the front end for the Jet database engine. Jet is nice in that it is part of the windows platform, no additional installation required (note, is a jet engine update to 4.0)

  SQL stands for Structured Query Language. Database platforms have their own versions of the language - Jet SQL, T-SQL (SQL Server) P-SQL (Oracle) just to name a few. These are all based on, but vary in some ways from, the ANSI-SQL standard. You should learn basic SQL no matter what platform you use.

  Remember, if you use jet, you will need to implement a compaction routine via the JRO (Jet Runtime Objects) as part of your application maintenance. When objects are deleted or updated (an update is an insert followed by a deletion) the records are not actually deleted, just marked as old. compacting is the process of actually clearing out the old records.

  Now, if you are going to have more than one application instance interfacing the database at one time, Jet can be a royal pain.

  
  
  

• Kishore Annavarapu

  shakalama wrote:

  Question : - i saw many times ppl use (front end and back end) <<< what does that mean and forgive me because i'm not english speaker

  The "front end" typically refers to the user interface of the application or the application itself. The "back end" typically refers to the database and sometimes the software that interfaces with the database, remote and separate from the "front end".

  
  
  
• MS Access and VB