Opening files using VBS

C

CorporateQAinTX

I found a thread regarding opening an MDE using some VBS code. My problem is
that I'd like to open the file using Access Runtime.

I can open the MDE using a shortcut I created
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /runtime "actual
file path"
But, even though I can open it, no one else can because their security won't
allow it.

So here's the code I'm using:

dim o
set o=createobject ("Access.Application")
o.automationsecurity=1 ' low.
o.opencurrentdatabase "\\server\workgroup\filepath"
o.visible=true
o.usercontrol=true
set o=nothing

Is there a way to incorporate the runtime code into this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top