Solved

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

Posted on 2012-03-15
10
293 Views
Last Modified: 2012-03-16
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
0
Comment
Question by:SeyerIT
  • 3
  • 2
  • 2
  • +2
10 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 84 total points
ID: 37725593
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 167 total points
ID: 37725772
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
 
LVL 2

Author Comment

by:SeyerIT
ID: 37725863
Thanks you two.. Let me browse through these.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 167 total points
ID: 37726372
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 166 total points
ID: 37726478
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37726690
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
 
LVL 8

Expert Comment

by:Wiesje
ID: 37726875
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
 
LVL 8

Assisted Solution

by:Wiesje
Wiesje earned 83 total points
ID: 37726898
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
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 166 total points
ID: 37728647
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
 
LVL 2

Author Comment

by:SeyerIT
ID: 37728912
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now