can you compile? an access 2010 project into a standalone file (exe)

[IamKJVonly]

Its been a few years since I have been in access 2010 and I was stopped because, I couldn't run my access programs unless I ran through them through the access program which clutters up the screen. is there any way I can run an access 2010 program with out being in the access 2010 program something like an exe file ?

I'm probably not saying it right because I can't find what I want through a search.


I want to try access 2010 again but I need to know if I can do this or not.

thanks for any information you can give me.
Dave

[orange]

You may want research Ms Access accde file.
Here's a link but there are several.

[IamKJVonly]

Thanks a lot you just made my day. that is just what I wanted to see.
I don't know why I couldn't find this information 2 years ago./
Thanks again and have a blessed day
Davde

[CJ_London]

Unless I ran through them through the access program which clutters up the screen

to be clear, any access application needs the access environment (the access.exe in program files), it won't run 'standalone' as you might with .exe's. Users can use what is called the runtime version (free) rather than the full version. The .accde file simply means that users cannot modify forms, reports or modules.

However your app can hide the access window. All forms and reports will need to be popups or subforms and so far as I am aware you cannot open queries in popup mode - you would need to use a form or report as a 'container'. However if this requirement is for security reasons, there are ways a sophisticated user can unhide the access window and therefore gain access to the tables and queries.

There are plenty of links around hiding the access window - here is one

https://www.access-programmers.co.uk...window.218554/

My style is to have a single popup main form with access window hidden and all other forms are initially displayed as a subform but with the ability to 'lift' the subform off the main form to display in a separate window (if required for reference or comparison purposes for example). A similar effect can be achieved by not hiding the access window and instead ensure the app is set to tabbed documents and hiding the navigation window and ribbon are hidden instead. Show document tabs or not, depending on the requirement.