Sign in to follow this  

Visual Basic.Net and MS Access database...

This topic is 4388 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

Hello. I am writing an application that needs to read from and modify data stored in a Microsoft Access database using (preferably) Visual Basic.Net. This database exists locally in the application directory. I believe I should be able to access the database with reasonable ease, but unfortunately I just can’t seem to locate any information on exactly how to do that. Could someone perhaps point me in the right direction? Thanks in advance, Jackson Allan

Share this post


Link to post
Share on other sites
Look into ADO .NET. It is a library built for the .NET technologies to easily allow you to interface with many different kinds of databases. Most decent VB .NET books will feature a chapter dedicated to using the ADO .NET SQL Server library classes which generally begin with SQL (ie: SqlConnection, SqlCommand, etc). To interface with an MS Access database you will instead use the OLE database classes which generally begin with OleDB (ie: OleDBConnection, OleDBCommand, etc). Try doing a search on google for using these keywords: ADO .NET, VB .NET, MS Access. You should be able to find some tutorials on code guru or a site like that. Hope this is not confusing, I've been awake for 24 hours now! :-(

- Bill

I'd personally Recommend the "WROX Beginning (C#/VB .NET) Databases" books if you can find them cheap. I was able to purchase my copy for $7.00 USD.

Share this post


Link to post
Share on other sites

This topic is 4388 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this