Previous Thread:   An file representing MS Access report got "stuck" in checked out state

6/26/2006 2:07:02 PM    How Do I Start Distributing an Access Application
I'm finishing up the final stages of testing and developing a Microsoft  
  
Access application that is equipped to interface with Microsoft Project and  
  
potentially several other applications.  I'm really not sure where to begin  
  
besides turning it into an MDE file to protect my code, but beyond that, I'm  
  
not quite sure.  
  
How can I ensure that my product will be usable on multipile machines?  What  
  
options are there for allowing it to work on computers that do not have  
  
Access?  What kind of simultaneous multi-user capability can I expect, and  
  
how can I make sure that no data is lost?  What steps must I take to make  
  
sure that Microsoft will not take issue with my selling this application?  
  
Are there any other issues I must be aware of?  
  
Any information, suggestions, websites, or other ideas you have on this  
  
subject (including a better place to post this question), would be greatly  
  
appreciated.  
  
Dustin



6/27/2006 4:29:15 AM    Re: How Do I Start Distributing an Access Application
Dustin Ventin wrote:  
  
Computers without Access will need to have the runtime version of Access installed. You  
  
get a license to distribute the Access run-time when you purchase Visual Studio Tools (the  
  
actual package depends on what Access version you are using).  
  
http://office.microsoft.com/en-us/assistance/HA011208861033.aspx  
  
http://www.developer.com/tech/article.php/721181  
  
http://www.granite.ab.ca/access/runtime.htm  
  
http://support.microsoft.com/kb/q162522/  
  
A multi-user app should be split into front-end/back-end model. Number of users depends on  
  
how well your app and code is done.  
  
http://www.granite.ab.ca/access/  
  
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm  
  
http://allenbrowne.com/ser-01.html  
  
http://support.microsoft.com/?scid=kb;en-us;304932&spid=2509&sid=49  
  
http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1194990&page=0&view=collapsed&sb=5&o=&fpart=all&vc=1  
  
Lots of issues. Search Google Groups for more specific info and programmer experiences.  
  
--  
  
'---------------  
  
'John Mishefske  
  
'---------------

6/28/2006 2:54:32 AM    Re: How Do I Start Distributing an Access Application
Dustin Ventin wrote:  
  
I haven't used SageKey (yet) but based on usenet posts its the best. It handles the FE/BE  
  
arrangement used for multi-user apps in Access and specializes with installing the Access  
  
runtime. I've read very good reviews. It does cost some $$ but it sounds like it is well  
  
worth it.  
  
http://www.sagekey.com/  
  
--  
  
'---------------  
  
'John Mishefske  
  
'---------------

6/28/2006 10:45:23 PM    Re: How Do I Start Distributing an Access Application
Dustin Ventin <DustinVentin@discussions.microsoft.com> wrote:  
  
Where Sagekey really shines is if the client workstation already has  
  
some version of Access installed on it.    The Sagekey install is  
  
completely independent of whatever version of Access is already  
  
installed on the system.  
  
Which, of course, you can't control if you are not in a single  
  
corporate environment.  
  
Tony  
  
--  
  
Tony Toews, Microsoft Access MVP  
  
Please respond only in the newsgroups so that others can  
  
read the entire thread of messages.  
  
Microsoft Access Links, Hints, Tips & Accounting Systems at  
  
http://www.granite.ab.ca/accsmstr.htm

6/29/2006 2:13:05 AM    Re: How Do I Start Distributing an Access Application
Dustin Ventin wrote:  
  
Installation on multiple platforms? SageKey is the only installer product that I know of  
  
that targets Access installations (and especially the Runtime). As I understand it SageKey  
  
is an add-on to your base Installation package (Wise, InstallShield).  
  
I personally use NSIS for all my installs, even the Access runtime. While it is a powerful  
  
installation tool it is not an easy tool to use; it has a bit of a learning curve. But it  
  
is open-source so you can make it do anything that you can code it to do.  
  
Did I understand your question correctly?  
  
--  
  
'---------------  
  
'John Mishefske  
  
'---------------

7/1/2006 9:34:00 PM    Re: How Do I Start Distributing an Access Application
Dustin Ventin <DustinVentin@discussions.microsoft.com> wrote:  
  
SageKey is a major improvement of what MS offers in their ODE/MOD/ADE.  
  
In a controlled environment, such as within a medium sized or larger  
  
corporation, then that maybe all that is required.  But if you're  
  
distributing your app to systems over which you have no control then  
  
you'd be best using Sagekey.  
  
Tony  
  
--  
  
Tony Toews, Microsoft Access MVP  
  
Please respond only in the newsgroups so that others can  
  
read the entire thread of messages.  
  
Microsoft Access Links, Hints, Tips & Accounting Systems at  
  
http://www.granite.ab.ca/accsmstr.htm