Access 2007 Package and Distribute Suggestions (1 Viewer)

[padlocked17]

All -

I have just about finished up a Split DB that I plan on deploying in a LAN environment. The goal of course is to turn what looks like an Access Application now into a non-access looking application where the Front End can be distributed and run on any computer within the LAN.

I have several questions that I may need some help on.

How does one go about hiding the Access Shell and/or Ribbon/Nav in 2007?

How would I add a form that allows for a user to navigate to and connect to the back-end without having them check all of the appropiate tables and then browse to the back-end file if they have a different drive letter mapped to the location of the back-end files for example?

Any tips on how to sign the DB so the pesky Trust Center question can be bypassed?

Any other tips on how to simply distribute this for a LAN environment and/or make it look NOT like an Access DB with access to view the Forms, Tables, Queries, etc. This is my first Access DB project, let alone a LAN distributable one.

Thanks!

 

[boblarson]

Check out this page here -

http://accessjunkie.com/faq2007.aspx

I believe it has almost all of your questions answered.

 

[padlocked17]

Awesome. I've been going through them one at a time. I appreciate the link.

I'm sure when questions arise, I'll be back.

 

[weekendwarrior]

I've had the exact same problem with regards to getting rid of the Access Shell. I checked out the link BobLarson provided but didn't spot it there. I guess I'm just a slow learner - could you be more specific about where to find that one. I really tried to find it but just couldn't spot it.

Thanks.

 

[boblarson]

I've had the exact same problem with regards to getting rid of the Access Shell.

There is no "setting" to get rid of the Access shell. You have to set all of your forms to run as popup, you have to use DoCmd.RunCommand acCmdAppMinimize to minimize the Access window.

It isn't all that easy to do well.

OR, you can try to use this:

http://www.mvps.org/access/api/api0019.htm

 

[weekendwarrior]

Thank you very much for your advice - it was right on.

I made an effort to search for solutions myself but wasn't using the right key words. I didn't think of "access shell" as the right search phrase.

Your cmdAppMinimize idea was exactly right, as well as the tip about making the forms and reports popup. And by using the proper search term I learned more in some other places about the right way to use it.

Thanks again.

 

[cvajniga]

See http://msdn.microsoft.com/en-us/library/bb258192.aspx

There's a slight typo in the MS example so that you should use the following code:

<CustomUI xmlns="[URL]http://schemas.microsoft.com/office/2006/01/CustomUI[/URL]"> <Ribbon startFromScratch="true"></CustomUI>

WARNING:
Without Ribbon you will miss the Add In tab where you can find your commandbars from previous version of your application. You could try to build Quick Access Toolbars (QATs) to replace commandbars but QATs are really buggy.

Also see:
http://www.alis.cz/relax/download/beta/Access2007_bugs.rar 27.3MB
pwd = A2007bugs

 

[cvajniga]

One more thing:
A2007's PSW doesn't include referenced files & their dependencies in the MSI file!!! Be sure you have a tool to install referenced files in a standalone installation setup. The standalone setup may be included in so called "chained install" - you must adapt the Setup.ini manually, see http://msdn.microsoft.com/en-us/library/bb687991.aspx.

HTH