locked
.mdb file RRS feed

  • Question

  • have anybody used Free Address Book it has a .mdb database file, but it does not require sql server to run the software, and it operates the database as well,

    So can anyone tell me how does this software uses sql server or ms access file without the need of the sql server.

                                                                              

                                                                                                                                               Thanks in advanced.

    Monday, August 30, 2010 11:10 AM

Answers

  • An mdb file is Jet database engine file (http://en.wikipedia.org/wiki/Microsoft_Jet_Database_Engine) used by the Access application.  This is unrelated to SQL Server.  Modern versions of Access can also use SQL Server Compact or Express editions instead of Jet.


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Proposed as answer by Tom Li - MSFT Tuesday, August 31, 2010 9:40 AM
    • Marked as answer by Smith010 Tuesday, August 31, 2010 2:02 PM
    Monday, August 30, 2010 11:59 AM
    Answerer
  •                  Well thanks for your valuable support, But I want to know that how I can use .mdb database file to store and retrieve data without connecting to sql server. 


    The FAQ in the link you posted (http://addressbook.gassoftwares.com/faq.php#q1) provides the clue:

    connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents andSettings\[user's folder]\Application Data\GAS Softwares\Free Address Book\AddressBook.mdb"

    You should be able to open the file using Access or any OLEDB application program to use the database.


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Marked as answer by Smith010 Tuesday, August 31, 2010 2:03 PM
    Monday, August 30, 2010 10:51 PM
    Answerer

All replies

  • Hello,

    You can add the database file in to your project.

    http://msdn.microsoft.com/en-us/library/ms246989(v=VS.80).aspx  

    Hope this helps.   
     
    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, August 30, 2010 11:31 AM
  • An mdb file is Jet database engine file (http://en.wikipedia.org/wiki/Microsoft_Jet_Database_Engine) used by the Access application.  This is unrelated to SQL Server.  Modern versions of Access can also use SQL Server Compact or Express editions instead of Jet.


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Proposed as answer by Tom Li - MSFT Tuesday, August 31, 2010 9:40 AM
    • Marked as answer by Smith010 Tuesday, August 31, 2010 2:02 PM
    Monday, August 30, 2010 11:59 AM
    Answerer
  •                  Well thanks for your valuable support, But I want to know that how I can use .mdb database file to store and retrieve data without connecting to sql server. 
    Monday, August 30, 2010 5:36 PM
  •                  Well thanks for your valuable support, But I want to know that how I can use .mdb database file to store and retrieve data without connecting to sql server. 


    The FAQ in the link you posted (http://addressbook.gassoftwares.com/faq.php#q1) provides the clue:

    connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents andSettings\[user's folder]\Application Data\GAS Softwares\Free Address Book\AddressBook.mdb"

    You should be able to open the file using Access or any OLEDB application program to use the database.


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Marked as answer by Smith010 Tuesday, August 31, 2010 2:03 PM
    Monday, August 30, 2010 10:51 PM
    Answerer