Microsoft Developer Network >
Forums Home
>
Visual Studio Express Editions Forums
>
Visual Basic Express Edition
>
vb 2010 express and Access Database
vb 2010 express and Access Database
- 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
- 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)- Proposed As Answer byme.Ryan Friday, November 06, 2009 7:22 PM
- Marked As Answer byJeff ShanMSFT, ModeratorMonday, November 09, 2009 2:30 AM
All Replies
- 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) - 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)- Proposed As Answer byme.Ryan Friday, November 06, 2009 7:22 PM
- Marked As Answer byJeff ShanMSFT, ModeratorMonday, November 09, 2009 2:30 AM
- 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) - That is correct, however; his question is about the Express Edition (see title).
Paul ~~~~ Microsoft MVP (Visual Basic) - 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) - No problem, now we know how to do it in both. :-)
Paul ~~~~ Microsoft MVP (Visual Basic)

