opening mde using vbs

[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?

 

[dch3]

That thread might be something that I posted as I'm doing exactly that. We
have not run into any issues.

" their security won't allow it." - Is the front end in the ALL USERS
folder? (They can't open it because they may not have rights to each other's
folders. Move the file.)
What's the error message that you're given when they try to open it?

Are they able to use a shortcut to open it - and the error is only presented
when they try the .VBS Script? (If they can't run the VBS script that's a
IT/Network Admin security policy in place.)

 

[david]

You can open the runtime with a dummy file, and work from there.
With the runtime there must be a file.

Why are you trying to make users open a file that their security
won't allow? The system is specifically designed to prevent that
happening, so of course it will be difficult.

(david)

 

[CorporateQAinTX]

I guess I made it sound more like a network issue than software. The file is
in a folder that everyone has authority to access. I'm an administrator over
an internal website that links all of the sections of our quality system
together. People from all over the western half of the states access the site
on a regular basis, so I know that's not the issue.

I don't want anyone but me or any future DB admins from having access to the
tables and queries, so I found an article in the MSDN library regarding use
of Access Runtime and MDE's to add security by removing access to the
developmental side of Access. It works on my computer, but I authored all of
the VBA and Macros involved. When I try to open it on other computers, they
get messages similar to what you get in Excel when you try to open a file
with Macros and your macro security is set to high. Well I found the string
Access 2003 "Security Warning" under Access Security. Jeff Conrad offered the
vbs code I posted previously for lowering the security when Access opens.
(Sidenote: It works well on Excel as well for allowing Macros to run without
security errors)

The code will open the MDB or MDE directly, but I can't figure out how to
use the "/runtime" code in the VBS.

To sum it up, right now I can have poeple open a MDE in runtime, but they
have to know how to manually change the security settings in their Access
software. Or I can open the MDE directly with the security already lowered,
but they can access the tables, forms, queries, etc.

Does that make any better sense?