Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

A2003: Possible to create a downloadable EXE setup file?

 
   Database Help (Home) -> MS Access RSS
Next:  DSO question - AS2000  
Author Message
PW

External


Since: Dec 06, 2007
Posts: 54



(Msg. 1) Posted: Mon Dec 29, 2008 11:27 am
Post subject: A2003: Possible to create a downloadable EXE setup file?
Archived from groups: comp>databases>ms-access (more info?)

Hi,

I am using the Package Wizard that comes with Access 2003 Developer
Tools to distribute my application on a CD. It creates setup.exe
along with a couple other files and a folder. I'd like to be able to
put an EXE on our website that includes everything the setup program
needs so clients can download just one file. Believe it or not, many
of my clients are unfamiliar with something like WinZip and I have to
walk them through downloading it, installing it, and using it. If
there was one EXE file that would be fantastic!

Any ideas?

Thanks,

-paulw

 >> Stay informed about: A2003: Possible to create a downloadable EXE setup file? 
Back to top
Login to vote
lyle fairfield

External


Since: Apr 16, 2008
Posts: 174



(Msg. 2) Posted: Mon Dec 29, 2008 11:44 am
Post subject: Re: A2003: Possible to create a downloadable EXE setup file? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I haven't done this myself but I believe that 7-Zip, a free utility
will
- compress all your files to one self-extracting exe file (I've done
this much)
- make use of a config.txt file to run an .exe or .cmd or .msi file
(this would be your setup file) when decompressing is complete. (This
involves using an sfx file; I haven't done this).

This may be a bit gnarly to get just right but it's free, super small
and super fast.

7-Zip is at www.7-Zip.org


On Dec 29, 1:27 pm, PW
wrote:
> Hi,
>
> I am using the Package Wizard that comes with Access 2003 Developer
> Tools to distribute my application on a CD.  It creates setup.exe
> along with a couple other files and a folder.  I'd like to be able to
> put an EXE on our website that includes everything the setup program
> needs so clients can download just one file.  Believe it or not, many
> of my clients are unfamiliar with something like WinZip and I have to
> walk them through downloading it, installing it, and using it.  If
> there was one EXE file that would be fantastic!
>
> Any ideas?
>
> Thanks,
>
> -paulw

 >> Stay informed about: A2003: Possible to create a downloadable EXE setup file? 
Back to top
Login to vote
Tony Toews [MVP]

External


Since: Nov 15, 2007
Posts: 1217



(Msg. 3) Posted: Mon Dec 29, 2008 3:27 pm
Post subject: Re: A2003: Possible to create a downloadable EXE setup file? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

PW wrote:

>I am using the Package Wizard that comes with Access 2003 Developer
>Tools to distribute my application on a CD. It creates setup.exe
>along with a couple other files and a folder. I'd like to be able to
>put an EXE on our website that includes everything the setup program
>needs so clients can download just one file. Believe it or not, many
>of my clients are unfamiliar with something like WinZip and I have to
>walk them through downloading it, installing it, and using it. If
>there was one EXE file that would be fantastic!

Albert Kallal has suggested using Inno Setup in the past which is a free installer.
It works well.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 >> Stay informed about: A2003: Possible to create a downloadable EXE setup file? 
Back to top
Login to vote
PW

External


Since: Dec 06, 2007
Posts: 54



(Msg. 4) Posted: Mon Dec 29, 2008 5:11 pm
Post subject: Re: A2003: Possible to create a downloadable EXE setup file? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Mon, 29 Dec 2008 20:17:33 GMT, "Tony Toews [MVP]"
wrote:

>PW wrote:
>
>>I am using the Package Wizard that comes with Access 2003 Developer
>>Tools to distribute my application on a CD. It creates setup.exe
>>along with a couple other files and a folder. I'd like to be able to
>>put an EXE on our website that includes everything the setup program
>>needs so clients can download just one file. Believe it or not, many
>>of my clients are unfamiliar with something like WinZip and I have to
>>walk them through downloading it, installing it, and using it. If
>>there was one EXE file that would be fantastic!
>
>Albert Kallal has suggested using Inno Setup in the past which is a free installer.
>It works well.
>
>Tony

That looks good Tony. But, I just had a Homer Simpson "Doh!" moment.
I just remembered that WinZip can create an EXE file. That may do
what I want.

Doh!

-paulw
 >> Stay informed about: A2003: Possible to create a downloadable EXE setup file? 
Back to top
Login to vote
Albert D. Kallal

External


Since: Nov 18, 2007
Posts: 672



(Msg. 5) Posted: Mon Dec 29, 2008 5:41 pm
Post subject: Re: A2003: Possible to create a downloadable EXE setup file? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Here is a sample inno script which "wraps" the package wizard install into a
single .exe


[Setup]
SourceDir=c:\RidesRunTime
AppName=Rides Runtime System
AppVerName= Rides 1.5
DefaultDirName=c:\RidesRunTime
Compression=lzma
SolidCompression=yes

DirExistsWarning=no
DisableDirPage=yes
DisableProgramGroupPage=yes
Uninstallable=no


[Files]
Source: "*"; DestDir: "{app}"
Source: "files\*"; DestDir: "{app}\files"
Source: "files\setup\*"; DestDir: "{app}\files\setup"
[Run]
FileName: {app}\setup.exe; Parameters: "/qb"


I as a rule highly recommend that you split your install into two packages.

One install is the application part, and the other install is the runtime.
That way, issuing updates is the SAME process as installing the front end
part. You can simply "send" users to the same web site over and over for
updates. In fact, I used use

application.FollowHyperlink "web site path name to .exe"
application.quit

Do the above means that I could update my software with 2 lines of code!!

(I don't use the above anymore..but, it great way to update your software).

By separating the installs, it is a "bit" more work for the end user, but
then for updates it is FAR easier (and, I issue frequent updates to my
software).

So, on your web site you just have:

step 1: install application click here

step 2: install runtime click here

You can put the whole thing into one install, but I recommend you don't.
Furthermore, if you setup an install for your application part in inno, you
avoid the problems of trying to update your software (the package wizard
really does not do this well at all). And, without the runtime, your updates
are VERY small indeed....usually less then a 10 second download on high
speed net.

I now use a custom ftp routine + an inno script for updates. here is a
series of screen shots in access as to how my customers now update their
software:

http://www.kallal.ca/ridestutorialp/upgrade.html


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal.DeleteThis@msn.com
 >> Stay informed about: A2003: Possible to create a downloadable EXE setup file? 
Back to top
Login to vote
Tony Toews [MVP]

External


Since: Nov 15, 2007
Posts: 1217



(Msg. 6) Posted: Wed Dec 31, 2008 4:35 pm
Post subject: Re: A2003: Possible to create a downloadable EXE setup file? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

PW wrote:

>That looks good Tony. But, I just had a Homer Simpson "Doh!" moment.
>I just remembered that WinZip can create an EXE file. That may do
>what I want.

Yes, that works however you can have troubles when you go to uninstall the Access
runtime. For some reason it looks to the original install place for files or
something wierd like that. I don't recall the details now but I decided that was too
bizarre of a problem for users to deal with.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 >> Stay informed about: A2003: Possible to create a downloadable EXE setup file? 
Back to top
Login to vote
PW

External


Since: Dec 06, 2007
Posts: 54



(Msg. 7) Posted: Thu Jan 01, 2009 8:44 pm
Post subject: Re: A2003: Possible to create a downloadable EXE setup file? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Wed, 31 Dec 2008 20:50:24 GMT, "Tony Toews [MVP]"
wrote:

>PW wrote:
>
>>That looks good Tony. But, I just had a Homer Simpson "Doh!" moment.
>>I just remembered that WinZip can create an EXE file. That may do
>>what I want.
>
>Yes, that works however you can have troubles when you go to uninstall the Access
>runtime. For some reason it looks to the original install place for files or
>something wierd like that. I don't recall the details now but I decided that was too
>bizarre of a problem for users to deal with.
>
>Tony

Thanks for the heads up Tony! I presently have our software installed
in C:\Program Files\Lodge-ical (in XP, hardly seems to be the same
place more than once in Vista!). Hmmm.. what to d...?

Thanks again,

-paulw
 >> Stay informed about: A2003: Possible to create a downloadable EXE setup file? 
Back to top
Login to vote
Tony Toews [MVP]

External


Since: Nov 15, 2007
Posts: 1217



(Msg. 8) Posted: Fri Jan 02, 2009 12:25 am
Post subject: Re: A2003: Possible to create a downloadable EXE setup file? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

PW wrote:

>Thanks for the heads up Tony! I presently have our software installed
>in C:\Program Files\Lodge-ical (in XP, hardly seems to be the same
>place more than once in Vista!). Hmmm.. what to d...?

I now install the FE MDE and associated files in the users Application Data folder.
If it's a stand alone product then the backend and associated files is storied in My
Documents.

By using Program Files for the Access MDE/MDBs the user either has to run as
adminstrator, run your app as an administrator or grant permissions for the user to
update that particular folder in Program Files. I did not want to subject my users
to any of that.

Now the runtime can get installed where it wants to as that has to be installed by an
administrator anyhow.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 >> Stay informed about: A2003: Possible to create a downloadable EXE setup file? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL create file - I've seen similar questions to this asked, but I haven't found a clear answer to this. I have a SQL file that basically creates all the tables and other predefined data. There are multiple statements, in the range around 100. In most other databases, i...

Create a text file for my data - Hi All, I have a spreadsheet where data has to be inputted from 12 users. Each user will have a blank copy of the spreadsheet, who will in turn fill it. At the top I have 7 coloums across the top (row 1) each colum has a name e.g Date | Name | Problem...

Create a Link in Access to a Text File - I am writing a little routine to perform the following operations from an Acces 97 mdb: 1. create a fixed width text file 2. create/establish a table type link to the text file in Access 3. allow the user to view the text contained in the text file via....

Create Excel file with VBA in Access - Here are 2 examples that I have found to create an Excel file with VBA. It is great for exporting data to Excel with the format that you want. Michael '---------------------------------------------------------------- Sub Test_Excel() Dim MyXL As..

Create a new tables with columns from Excel file - I need to create a new Access table with columns based on an Excel file. More Information: This task will come before I actually import the Excel file data into my data base. This Excel file may have different columns from time to time. The import....
   Database Help (Home) -> MS Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]