Can a user level version of access be run without the backround application displayed?

Anyone know if it is possible to only display a form when the access program is launched without displaying the entire Access App?

In other words, hide the part of the application highlighted in red in this screen shot;
sh
LVL 2
Jarred MeyerProduction ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
See here too:
http://access.mvps.org/access/api/api0019.htm

There was a thread a while ago where it was explained how to "Dim" the background, ...I'll try to look that up tonight.
0
Jarred MeyerProduction ManagerAuthor Commented:
Thanks you two.. Let me browse through these.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
It's not possible to hide the Access window, but you can set your Form to run as a popup the same size as the Access window (which is what the code suggested by others does). This will work to some degree - the user won't be able to see the Access window - but it comes with quite a few "gotchas".

For example, if the host program throws an error it could very well end up behind your giant popup form. The user couldn't get to it (since it's modal, and they can't move the popup form to get to it), so your app will be hung. Proper error handling is absolutely critical (and no more macros, period).

Also, this means that ALL of your forms must be set to popup. This may or may not work for you.

Also, your program must then be managed in a "linear" fashion, which detracts from one of the nice features of a Windows based program (the ability to switch back and forth easily between windows, and to have two windows side-by-side).

Those are just a few. If your do a search on the same topic, you'll inevitably see much more.

As I've said time and again - if you don't want the user to know this was done in Access, then don't do it in Access.
0
Jeffrey CoachmanMIS LiasonCommented:
Thanks LSM

...sometimes we forget to mention the "gotchas"

Stuff like this always seems "slick", but for the reasons you listed, (for me at least) it was just never worth all the hassle

I'll wit for Access to support this directly...

;-)

Jeff
0
WiesjeCommented:
There is another solution - you can actually create an Access executable (if I remember rightly). You only need the access runtime on the computer to be able to run it... and otherwise you do not see the Access background at all.

I will investigate this right now - and let you know how you go about this!!
0
WiesjeCommented:
Ok, I may have remembered wrongly. The only suggestions I see is using a RunTime version of Access instead of the full - but that doesnt solve your issue of hiding the background - as this you can still see.

The nicest solution I have found though - is using a VB or C# or other programming language front end - and only using the access database. Which means you can have a front end completely free of the access database. (And thus, hides all that).
See: http://www.access-programmers.co.uk/forums/showthread.php?t=153686 the esb1922 suggestion.

It's not as simple as the solutions suggested above - but it would work!

Hopefully you did not get your hopes up to high with an executable version - I must be remembering it wrong... sorry about that.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
There is no way to create an Access executable. Period. Full Stop. There are ways to kludge around it - create a "loader" program, etc etc - but all those do is implement the same sort of mechanism as described above (open the forms in Popup mode, and size them to hide the database window).

The Runtime version of Access is basically nothing more that the full version without the design-time capabilities. You still must "run" it to open your Access database, unlike other languages which rely on frameworks and such to generate the interface.
0
Jarred MeyerProduction ManagerAuthor Commented:
Thanks for all your help guys! I wasn't necessarily trying to make the program seem as though it didnt run in access.. I just made a simple widget that was rather small in window size that runs stand alone.. It's the entire program. So when it launched it also launched the backround window which took up the entire screen.. No biggie, I was just curious.

Thanks again for all your help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.