Open MS Access from Labview- -Not a Connection to Access

[DMerchen]

I want to open an Access DB from LabVIEW. I don't want to open a connection, I just want a button on the front panel that opens a specific Access DB file. I have a program that is reporting out information from this database, but I want to be able to open the database, make a change or updates, and then close the database. Update the form and poof, everything is up to date. I don't want to manipulate data from my program.

There has to be a way to open a database, right? I have searched on this subject, and I can not find a method that has worked for me to open a database.

Any help is greatly appreciated!

Dave

[JensG69]

Have a look at the Database Connectivity Toolkit

Regards, Jens

[DMerchen]

But that is used to open a connection to Access. Not what I want to be doing. I want to click on the button and open a specific database. Like if I went into explorer and double clicked on the file and it opened in Access.

Thanks,

Dave

[JensG69]

I'm not sure if I really understand what you try to achieve. Do you want MS Access to start and then open the access db file? Or another Executable? In that case have a look at the System Exec VI

Regards, Jens

[njacacia]

check out  https://stackoverflow.com/questions/16657263/opening-an-ms-access-database-from-the-command-line-wit...

[DMerchen]

Your description is correct Jens. I have looked at the System Exec VI and I haven't gotten it to run or open the file I want it to open. I thought that should work too. Perhaps I need to just mess with it some more. 

Thanks,

Dave

[jcarmody · Accepted solution]

Am I missing something?  This'll open a particular Access database in Access.

[DMerchen]

Thank you for the example. I have been trying to figure this out, but I didn't think it would be this simple. I shall give this a go. Thanks!!

[DMerchen]

Thanks! It was just too simple! I of course was overthinking it and trying too many different things. That space in between is critical as well!

Thanks again!

Dave