I want to turn off the access shell and only display what I have created. I want it to float on the desktop as if it's a standalone program.

I searched the forums and I found several useful posts concerning this topic but i just wanted to investigate further. I thought I had done this once before in an OLD access program by renaming the file extension. Apparently not?

I'm using MS Access 2007 and the database I built was for the earlier version. Now, I have less room to work with because of the big bulky bars at the top of Access. Then I realized that everyone will see these big bulky bars and confusing menus. I don't want them to see all that, is there a way to turn them off? Like in excel, you can turn off a lot of the extras before you send it out. It makes it look a lot cleaner, etc...

I read about the workaround, but my knowledge in Access is not 100%. This option doesn't seem feasible anyway.

1. Personally I wouldn't go there (making the Access shell go away) as it is a pain in the @$$ to manage everything and you lose right-click menu capability, etc.

2. If you make your database a runtime version (change the accdb to accdr) you will no longer have the ribbon on top, unless you provide one of your own. Also let your users know they can minimize it by simply hitting F1 and then F1 again to bring it back (when not in accdr).

I second Bob's recommendation. I know many that have tried and just gave up after wasted many days/weeks of trying.

I have implemented it into a few of my Databases. Looks good, but now the users are complaining they cannot use right click to copy and paste.

This has created a problem for me because if I remove this they will be able to use right click, but then complain that it doesn't look as good. They won't understand that they can't have both.

Take the advice given above and don't bother making your Database look like a standalone application, it will certainly cause headaches in future.

actually he or she doesnt know what he or she wants. basically it is possible to make the form float like an executable file and just hide the access application. its here in the forum somewhere i just dont remember where. :)

I think the OP knows exactly what they want. Unfortunately it is not a good idea, as I have learned the hard way.

The code doesn't actually hide the Access window, it minimises it which makes it appear to be hidden. This does however disable right click, which is a real pain the the ***

If the OP really does want to do this then the code I used can be found here - http://www.tek-tips.com/faqs.cfm?fid=2562

But remember:-

1. This will disable right click.
2. You will have to set all of your forms Pop Up properties to Yes.
3. You will have to add code to all of you reports OnOpen/OnClose events to run the restore/hide macros.

It is your choice, but I would advise you against this.