How to open MS Access in Runtime using Excel VBA?

Question

I'm struggling on how to open MS Access Runtime using VBA, from an Excel file.

You can open the full version of Access using CreateObject("Access.Application"), but that doesn't open Access in Runtime.

We only have Microsoft Access Runtime installed in some computers, because that's all we need to use the front-ends we've developed. So we need to open the accdb files using MS Access Runtime, but from Excel.

Any help is appreciated, thank you

Can you clarify what you mean with "in runtime"? Is Access supposed to magically open with a specific database and run a specific macro without you telling it? — Mathieu Guindon
– Mathieu Guindon, Commented Feb 20, 2017 at 18:50
Yes - we only have Microsoft Access Runtime installed in some computers, because that's all we need to use the front-ends we've developed.So we need to open the accdb files using MS Access Runtime, but from Excel. — Ana
– Ana, Commented Feb 20, 2017 at 18:53
I'd suggest you edit your question to include that somewhat crucial information. — Mathieu Guindon
– Mathieu Guindon, Commented Feb 20, 2017 at 18:54
Windows Script Host Object Model WshShell.Exec, or Microsoft Shell Controls and Automation Shell.ShellExecute — user20416
– user20416, Commented Feb 20, 2017 at 19:02

KevenDenen · Accepted Answer · 2017-02-20 19:27:09Z

3

You can use the Shell to open a file, as if you typed that command into window's command prompt.

d = Shell("pathToFile\Database1.accdb /runtime", vbNormalFocus)

Another option you could use to open in the file in runtime (if someone opens it from the folder or through some other method without the /runtime switch) would be to change the file extension to .accdr. This will always force runtime.

answered Feb 20, 2017 at 19:27

KevenDenen

1,72213 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ana Over a year ago

Thank you so much! I did something very similar and it's working now CreateObject("WScript.Shell").Run ("""pathToFile\Database1.accdb""")

Collectives™ on Stack Overflow

How to open MS Access in Runtime using Excel VBA?

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related