Visual basic and Microsoft Access

Posted on 2011-10-25
Last Modified: 2012-05-12
hello guys i want to make a software that uses access at back end i have made like all pages in access i want them to be operated via vb .net program to add data to those pages,edit any data and delete if required and store the data so question is what things i need o do????

m using vb .net 2008 and ms access 2007
Question by:rosa545
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    From what you posted here, ...why not just migrate the entire app to
    Thus eliminating all of the potential "Interoperability" issues...
    LVL 40

    Expert Comment

    by:Jacques Bourgeois (James Burger)
    Why do you want to do it that way?

    Is there a reason why you do not do it entirely in VB.NET or entirely in VBA Access?

    Author Comment

    no there is no specific reason i just want to learn that integration can that be done or i wud have to make every thing from scratch in VB .net
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    I have not seen that much info on this.

    Kinda like asking can Windows 7 be configured to control DOS...

    So if this is something you are doing out of "Curiosity" then that is another story...

    You may have to post some very specific scenarios and post detailed descriptions of your existing systems...

    LVL 5

    Expert Comment

    Here is an article on converting VBA code to .NET, hope it is useful:

    Personally I would rather rewrite in VB.NET from scratch though...
    LVL 40

    Accepted Solution

    I have never seen a scenario where it would be useful to have a .NET application control the forms in an Access database.

    Usually, .NET is used to work with the tables and the queries and provides the screens as Windows Forms. You do not connect to Access to do that, you do it with ADO.NET or one of the .NET technologies that wraps around ADO.NET (Data Entities or LINQ).

    As an alternative to what is available in .NET for reporting, you might however use Access for its reports capabilities. Since most of my customers used Access before I moved them to SQL Server, Access is available on their station, and I use it as a report generator for most of their applications, with code such as this one:
    Dim accessApp As Access.Application = New Access.Application
    accessApp.OpenAccessProject("<Path + Database>.mdb") 'or .accdb
    accessApp.DoCmd.Close(Access.AcObjectType.acReport, "<ReportName>")

    Open in new window

    Note that you could use similar code to work with the forms if you wanted to, but as told before, creating the forms in .NET would be a better choice if you need your .NET application to interact with the database.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Suggested Solutions

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now