Opening Access 2010 database with VB.Net 2008

Posted on 2011-04-19
Last Modified: 2012-06-27
I use this to open earlier versions of access.  Obviously doesn't work with Access 2010.  How do you open an "accde" file with  Do you have to convert it to a .mde or .mdb first?  

Dim objAccess As Access.Application
objAccess = New Access.ApplicationClass()
objAccess.OpenCurrentDatabase("database path", False, "")

objAccess = Nothing

Any help would be great!


Question by:transstates
    LVL 53

    Assisted Solution

    What do you want to do ? I don't recommend to use access.application, ... but use

    See Data Programming with Access 2010

    Author Comment

    Thanks for the help.

    What I'm trying to do is just open and access database, "accde" file.  This db contains a list of reports to print.  So I just need to open it and then close the msaccess.exe when the user is finished.


    Author Comment

    When this access database opens, it has a startup form that will guide the user the rest of the way. I just need to open it like you would a regular .mdb.  The above code opens the startup form for previous versions of access.
    LVL 83

    Accepted Solution

    Did you try Process.Start("path of the file")?

    Author Closing Comment

    Dhaest, I only gave lower points becuase the process.start actually did what I need for the quick fix.  Your link is very helpful for doing more work with access.  

    I thank you both so much for the help!!

    LVL 83

    Expert Comment

    Glad to help :-)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
    Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
    This video discusses moving either the default database or any database to a new volume.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now