Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Developer Toolkits / January 2008

Tip: Looking for answers? Try searching our database.

Updating Distributed Access Application

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
chasday - 23 Dec 2007 14:18 GMT
I am using Access 2007 and the Package Solution Wizard to distribute my
application. So far it works great.
How does one distribute Updates? When I try it by just running the Wizard
again the user must uninstall the original edition before continuing. Is
there a way to aviod this?
It would seem that the Product and/or Update codes can be used for this but
how to do it isn't clear in the MS documentation.
Douglas J. Steele - 23 Dec 2007 19:20 GMT
Your application should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relations). Only the back-end should be on the server: each user
should have his/her own copy of the front-end, ideally on his/her hard
drive. With that set up, all you have to do is replace the front-end.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I am using Access 2007 and the Package Solution Wizard to distribute my
> application. So far it works great.
[quoted text clipped - 4 lines]
> but
> how to do it isn't clear in the MS documentation.
chasday - 23 Dec 2007 19:49 GMT
I've already done all that. What I want to do is to be able to do is package
the application revisions/updates so that they "overwrite" the existing front
end with out the user having to uninstall the existing version.

> Your application should be split into a front-end (containing the queries,
> forms, reports, macros and modules), linked to a back-end (containing the
[quoted text clipped - 10 lines]
> > but
> > how to do it isn't clear in the MS documentation.
Tony Toews [MVP] - 23 Dec 2007 22:59 GMT
>I've already done all that. What I want to do is to be able to do is package
>the application revisions/updates so that they "overwrite" the existing front
>end with out the user having to uninstall the existing version.

I'm very shortly going to be writing a routine which, when the user
clicks on the appropriate command button, hits my website and
downloads the updates, unzips it and puts it into place.  Of course I
also have to get this going with the Auto FE Updater so it's not that
simple.

Just thinking out loud here.

Tony
Signature

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
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Douglas J. Steele - 24 Dec 2007 12:48 GMT
No packaging nor uninstall is required. You strictly overwrite the
front-end.

While Tony mentioned an update he's planning for his free Auto FE utility,
what he currently has should be sufficient for your needs. Take a look at
http://www.granite.ab.ca/access/autofe.htm

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> I've already done all that. What I want to do is to be able to do is
> package
[quoted text clipped - 20 lines]
>> > but
>> > how to do it isn't clear in the MS documentation.
Tony Toews [MVP] - 24 Dec 2007 18:21 GMT
>While Tony mentioned an update he's planning for his free Auto FE utility,

Actually I'm going to be putting the same logic in both the Auto FE
Updater and my applications.

Tony
Signature

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
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

George Nicholson - 26 Dec 2007 17:49 GMT
Don't use the packaging wizard for updates. It simply isn't designed for it
(Over the years, I've had so little luck getting it to do anything well, I'm
tempted to insert some pot shots about what it is actually designed to do,
but I won't.).

Either:
1) have an update strategy pre-built into the app. When opened, the app
checks for new fe on the network, copying it to local if found.
http://www.databasejournal.com/features/msaccess/article.php/3286111
outlines a basic approach.

2) use a tool like Tony Toews' Auto FE Updater. A process similar to the
above, but utilizes an external exe and users *have* to use your shortcuts
to open the app or they'll bypass the file check)
http://www.granite.ab.ca/access/autofe.htm

There are multiple variations of #1 and #2

3) use a real installer (like the free Inno setup) to distribute an
executable that contains just the update.
http://www.jrsoftware.org/isinfo.php

Signature

HTH,
George

> I've already done all that. What I want to do is to be able to do is
> package
[quoted text clipped - 20 lines]
>> > but
>> > how to do it isn't clear in the MS documentation.
katja.ulaga - 26 Jan 2008 19:56 GMT
> I am using Access 2007 and the Package Solution Wizard to distribute my
> application. So far it works great.
[quoted text clipped - 4 lines]
> but
> how to do it isn't clear in the MS documentation.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.