Ask a questionAsk a question
 

Answervb 2010 express and Access Database

  • Wednesday, November 04, 2009 4:39 PMmreed72 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I downloaded the beta 2 of VB 2010 and converted my project over from 2008 (made a backup so I can still work in 2008)  but I find that their isnt a way to connect to an access database from 2010 like there was in 2008.

    I tried the local database, but that creates an sdf file. 

    is their something I'm overlooking?

Answers

  • Friday, November 06, 2009 12:27 AMPaul P Clement IVMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Just to clarify the instructions here, it's View...Other Windows...Database Explorer. Then you can right click on Data Connections in the Database Explorer window and select Add Connection.

    To add a data source click Data...Add New Data Source...click Database in the Data Source Configuration Wizard, Next button, DataSet as the data connection and then the New Connection... button. If the Data Source in the Add Connection dialog is not Microsoft Access Database File (OLE DB) then click the Change... button. Then select Microsoft Access Database File from the Change Data Source dialog and then click the OK button.
    Paul ~~~~ Microsoft MVP (Visual Basic)

All Replies

  • Wednesday, November 04, 2009 5:58 PMme.Ryan Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    To connect to a Database that already exist is simple:

    Goto View on your menu and then select "server explorer"
    it will appear in the left of the screen normally, just click on connect to database and it's done.


    or do the same as above but just fill in by the name a not existing name of a database.

    Hope it works, Srry for my bad english.
    Thanks for answering my questions, Please explain in code, and for other programming languanges than VB2008.net explain very clearly. My programming skills are:(1 to 5) Html = 4 php = 1 VB2008 = 3,5 c++ = 1 (starter)
  • Friday, November 06, 2009 12:27 AMPaul P Clement IVMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Just to clarify the instructions here, it's View...Other Windows...Database Explorer. Then you can right click on Data Connections in the Database Explorer window and select Add Connection.

    To add a data source click Data...Add New Data Source...click Database in the Data Source Configuration Wizard, Next button, DataSet as the data connection and then the New Connection... button. If the Data Source in the Add Connection dialog is not Microsoft Access Database File (OLE DB) then click the Change... button. Then select Microsoft Access Database File from the Change Data Source dialog and then click the OK button.
    Paul ~~~~ Microsoft MVP (Visual Basic)
  • Friday, November 06, 2009 7:31 AMme.Ryan Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    No, in VS2010 pro beta2 it's the server explorer.
    Thanks for answering my questions, Please explain in code, and for other programming languanges than VB2008.net explain very clearly. My programming skills are:(1 to 5) Html = 4 php = 1 VB2008 = 3,5 c++ = 1 (starter)
  • Friday, November 06, 2009 1:35 PMPaul P Clement IVMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    That is correct, however; his question is about the Express Edition (see title).
    Paul ~~~~ Microsoft MVP (Visual Basic)
  • Friday, November 06, 2009 4:48 PMme.Ryan Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Oh I'm sorry, I didn't new there was a Express edition of 2010, so I read it as VS2010.

    Srry.
    Thanks for answering my questions, Please explain in code, and for other programming languanges than VB2008.net explain very clearly. My programming skills are:(1 to 5) Html = 4 php = 1 VB2008 = 3,5 c++ = 1 (starter)
  • Friday, November 06, 2009 6:53 PMPaul P Clement IVMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    No problem, now we know how to do it in both. :-)
    Paul ~~~~ Microsoft MVP (Visual Basic)