Question from a non-programmer

[Guest]

Hi

I'm not a programmer so apologies if this is a really silly question.
I'm using VBA with Access for a piece of work.
Is it possible to create an executable file that will run without the user
seeing that Access is used.
Or will Access have to be opened to run the macro?

I'd really appreciate any help,

Thanks

 

[Douglas J. Steele]

Access has to be open to run the macro.

There's no way to create an executable out of an Access application.

 

[RD]

What is it that you're actually trying to accomplish? What is it that needs to
be hidden from the user and why? If the user is using Access, why would the
"executable" need to be ... umm ... stealthy?

Regards,
RD

 

[Steve]

You could use automation from Excel to open Access in a hidden state and run
the Access macro. The user would only see Excel and would never see that
Access is used.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)