Open an Access Database

[Joe4]

I am creating a script that copies over the most recent version of a Front-End Access database to a user's hard-drive, and then opens it.  I have researched and seen lots of topics on connecting to an Access database, but I am not trying to do that.  I am simply trying to open it for them.

In a DOS batch file, the file to do that would look something like this:

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\Databases\MyDatabase.accdb"

So, what is the equivalent statement I would use in an AutoIt script to open the Access database?

Thanks

[Danp2]

Please clarify: Are you trying to launch MSAccess on the user's workstation or are you trying to access / read from the database directly from your script?

[JLogan3o13]

Hi, Joe4, welcome to the forum. Look at Run in the help file, the syntax would be almost identical.

Edit -  Or, look at ShellExecute: 

ShellExecute("C:\Databases\MyDatabase.accdb")

 

Edited May 22, 2015 by JLogan3o13

[Danp2]

If you just want to launch Access similar to the batch file, then you should take a look at the Run and ShellExecute commands in the help file.

[Joe4]

Thank you!

ShellExecute did the trick!