472,782 Members | 1,723 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,782 software developers and data experts.

Is there a stand alone installer for Access 2003 Runtime?

I have a desperate short term need for a way to install Access 2003
runtime on client computers. I have the proper license to do so but I
cannot seem to find the files to do it like we did with the old Access
2000 Runtime. Also, I cannot use the MS Package & Deployment wizard
because it won't allow us to install our app into the specific path
that it must be in. It only seems to allow preset macros to define
the target install path -- none of which will work for our app.

The short term solution is simply to install Access 2003 Runtime with
a separate install package.

Ultimately, we'll do it with a Wise install package. But that's a
whole Usenet group in itself and a lot of work for our app. We're
developing that now but we have beta testers who need Access 2003 NOW
and we don't want to force them to buy it.

Any advice?

Thanks folks.

-- LW
Jan 24 '06 #1
10 6011
> Deployment wizard
because it won't allow us to install our app into the specific path
that it must be in.

Hum..the package wizard on 2 of 7 allows you to choose the common settings
where your application should be installed.

They are:
Desktop, program files, Common App Data etc.

I can't imagine why you would want to install to anywhere else then those
above common directories. The options for the
target directory where your appcation installs is plenty covered by the
options given above. I see no reason why
you say you have no control as to where you application goes.
The short term solution is simply to install Access 2003 Runtime with

a separate install package.

Yes...the location of the runtime certainly can't be chosen. (but...who
cares.??? why does it matter?). To be sure, the a2003 p & d does use
whatever directory the user installed office to. And, if the location of the
directory is non standard, then it is true that the p & w CREATES WRONG
shortcuts. This is exactly why I had to dump the p & d for the a2003.

In fact, what I do is simply package the a2003 runtime with the p & d, and
then build my OWN install using iiino. The reason for this is that upgrades
are easer to do..and further, the shortcuts are correct....

So, just build the runtime install with the p & d as per above.

At this point, you now can use one of many installers to simply setup you
mde file. Remember, once the runtime is installed, then all you really have
to do is "copy" your mde file tot he users copter..and it will work. There
is noting "special" you have to do here..and it is a just a plane Jane mde
file as usual.

If things were simple..then you could use www.winzip.com.

I used to use the above WinZip for a consider amount of time (if you
registered WinZip for a very low fee..it will create self extracting zip
files for you).
After all...usually the only thing I needed to do was un-zip a mde file to a
particular directory.

So, once you have the runtime installed using the p & d...for deployment of
the mde..and building shortcuts etc....just use something else.

The best approach I found is to use the free Inno installer. It really is
nice..and is easy to use. (and it is free). And, since these innno scripts
really only have to install a mde file..and setup a few shortcuts for
you...they are very easy to write.

you can find the free inno installer here:

http://www.jrsoftware.org/isinfo.php

I highly recommend using the inno for installing your mde files and setting
up shortcuts. And, I see no reason not to continue to use the access 2003
and the package wizard to deploy the runtime part...

If you *really* must change the location as to where the runtime
installs..then you can purchase some scripts here:

www.sagekey.com
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal
Jan 24 '06 #2
Thanks Albert. Obviously, I blurred the distinction between our need
to install ART 2003 and the actual app. We must install the APP
itself to a specific, hard coded location for security reasons I am
not allowed to reveal, but the location of ART is irrelevant, as long
as it works.

I'm embarrassed to admit I did not think of using the P & D Wizard to
install just ART.
On Tue, 24 Jan 2006 11:44:54 GMT, "Albert D. Kallal" <ka****@msn.com>
wrote:
Deployment wizard

because it won't allow us to install our app into the specific path
that it must be in.

Hum..the package wizard on 2 of 7 allows you to choose the common settings
where your application should be installed.

They are:
Desktop, program files, Common App Data etc.

I can't imagine why you would want to install to anywhere else then those
above common directories. The options for the
target directory where your appcation installs is plenty covered by the
options given above. I see no reason why
you say you have no control as to where you application goes.
The short term solution is simply to install Access 2003 Runtime with

a separate install package.

Yes...the location of the runtime certainly can't be chosen. (but...who
cares.??? why does it matter?). To be sure, the a2003 p & d does use
whatever directory the user installed office to. And, if the location of the
directory is non standard, then it is true that the p & w CREATES WRONG
shortcuts. This is exactly why I had to dump the p & d for the a2003.

In fact, what I do is simply package the a2003 runtime with the p & d, and
then build my OWN install using iiino. The reason for this is that upgrades
are easer to do..and further, the shortcuts are correct....

So, just build the runtime install with the p & d as per above.

At this point, you now can use one of many installers to simply setup you
mde file. Remember, once the runtime is installed, then all you really have
to do is "copy" your mde file tot he users copter..and it will work. There
is noting "special" you have to do here..and it is a just a plane Jane mde
file as usual.

If things were simple..then you could use www.winzip.com.

I used to use the above WinZip for a consider amount of time (if you
registered WinZip for a very low fee..it will create self extracting zip
files for you).
After all...usually the only thing I needed to do was un-zip a mde file to a
particular directory.

So, once you have the runtime installed using the p & d...for deployment of
the mde..and building shortcuts etc....just use something else.

The best approach I found is to use the free Inno installer. It really is
nice..and is easy to use. (and it is free). And, since these innno scripts
really only have to install a mde file..and setup a few shortcuts for
you...they are very easy to write.

you can find the free inno installer here:

http://www.jrsoftware.org/isinfo.php

I highly recommend using the inno for installing your mde files and setting
up shortcuts. And, I see no reason not to continue to use the access 2003
and the package wizard to deploy the runtime part...

If you *really* must change the location as to where the runtime
installs..then you can purchase some scripts here:

www.sagekey.com

Jan 24 '06 #3

Well, I have now tried this. The P & D Wizard that comes with Office
2003 Dev Ext. will not allow me to create an install package that only
includes ART 2003. It MUST include a "valid" Access MDB or MDE or
Project file. Back to square 1.

Any other ideas? Or am I overlooking something


On Tue, 24 Jan 2006 11:21:35 -0600, Lauren Wilson <no****@nospam.com>
wrote:
Thanks Albert. Obviously, I blurred the distinction between our need
to install ART 2003 and the actual app. We must install the APP
itself to a specific, hard coded location for security reasons I am
not allowed to reveal, but the location of ART is irrelevant, as long
as it works.

I'm embarrassed to admit I did not think of using the P & D Wizard to
install just ART.
On Tue, 24 Jan 2006 11:44:54 GMT, "Albert D. Kallal" <ka****@msn.com>
wrote:
Deployment wizard

because it won't allow us to install our app into the specific path
that it must be in.

Hum..the package wizard on 2 of 7 allows you to choose the common settings
where your application should be installed.

They are:
Desktop, program files, Common App Data etc.

I can't imagine why you would want to install to anywhere else then those
above common directories. The options for the
target directory where your appcation installs is plenty covered by the
options given above. I see no reason why
you say you have no control as to where you application goes.
The short term solution is simply to install Access 2003 Runtime with

a separate install package.

Yes...the location of the runtime certainly can't be chosen. (but...who
cares.??? why does it matter?). To be sure, the a2003 p & d does use
whatever directory the user installed office to. And, if the location of the
directory is non standard, then it is true that the p & w CREATES WRONG
shortcuts. This is exactly why I had to dump the p & d for the a2003.

In fact, what I do is simply package the a2003 runtime with the p & d, and
then build my OWN install using iiino. The reason for this is that upgrades
are easer to do..and further, the shortcuts are correct....

So, just build the runtime install with the p & d as per above.

At this point, you now can use one of many installers to simply setup you
mde file. Remember, once the runtime is installed, then all you really have
to do is "copy" your mde file tot he users copter..and it will work. There
is noting "special" you have to do here..and it is a just a plane Jane mde
file as usual.

If things were simple..then you could use www.winzip.com.

I used to use the above WinZip for a consider amount of time (if you
registered WinZip for a very low fee..it will create self extracting zip
files for you).
After all...usually the only thing I needed to do was un-zip a mde file to a
particular directory.

So, once you have the runtime installed using the p & d...for deployment of
the mde..and building shortcuts etc....just use something else.

The best approach I found is to use the free Inno installer. It really is
nice..and is easy to use. (and it is free). And, since these innno scripts
really only have to install a mde file..and setup a few shortcuts for
you...they are very easy to write.

you can find the free inno installer here:

http://www.jrsoftware.org/isinfo.php

I highly recommend using the inno for installing your mde files and setting
up shortcuts. And, I see no reason not to continue to use the access 2003
and the package wizard to deploy the runtime part...

If you *really* must change the location as to where the runtime
installs..then you can purchase some scripts here:

www.sagekey.com

Jan 25 '06 #4

Lauren Wilson a scris:
Well, I have now tried this. The P & D Wizard that comes with Office
2003 Dev Ext. will not allow me to create an install package that only
includes ART 2003. It MUST include a "valid" Access MDB or MDE or
Project file. Back to square 1.

Any other ideas? Or am I overlooking something

Well then include a dummy mde or mdb files.

Sebastian

Jan 25 '06 #5
You really don`t need the P&D Wizard that comes with Office to install
only ART 2003. You will find the msi installer of ART 2003 in
'\Files\Accrt\Accessrt.msi' on your Office 2003 CD. Then as Albert said
you can use a installer (Inno installer is the best you can get for
free) to install your specific app files.

Sebastian

Jan 25 '06 #6
Lauren Wilson wrote:
I have a desperate short term need for a way to install Access 2003 runtime on client
computers.
I cannot use the MS Package & Deployment wizard because it won't allow us to install our
app into the specific path that it must be in. It only seems to allow preset macros to define
the target install path -- none of which will work for our app.
The short term solution is simply to install Access 2003 Runtime with a separate install
package.


Lauren, I recommend Agentix Installer: http://www.aginstaller.com
for building install package for the runtime.

It allows you to choose the specific path where your application should
be installed, works on all versions of Windows, creates a single-exe
setups, supports multilingual installations and has a complete set of
the gentleman's features - shortcuts creation, creation of registry and
..INI entries and more. It has it's own scripting mechanism, but it's
more easy to learn and use.

It is very impressive, doing almost everything Inno Setup does, but
producing setup files 250-290Kb smaller because of the very low (48Kb
only) overhead. It is not free, but is reasonably priced.

Feb 3 '06 #7
Lauren Wilson wrote:
I have a desperate short term need for a way to install Access 2003 runtime on client
computers.
I cannot use the MS Package & Deployment wizard because it won't allow us to install our
app into the specific path that it must be in. It only seems to allow preset macros to define
the target install path -- none of which will work for our app.
The short term solution is simply to install Access 2003 Runtime with a separate install
package.


Lauren, I recommend Agentix Installer: http://www.aginstaller.com
for building install package for the runtime.

It allows you to choose the specific path where your application should
be installed, works on all versions of Windows, creates a single-exe
setups, supports multilingual installations and has a complete set of
the gentleman's features - shortcuts creation, creation of registry and
..INI entries and more. It has it's own scripting mechanism, but it's
more easy to learn and use.

It is very impressive, doing almost everything Inno Setup does, but
producing setup files 250-290Kb smaller because of the very low (48Kb
only) overhead. It is not free, but is reasonably priced.

Feb 3 '06 #8
Thanks Alexey! I'll check it out. We actually already spent about
$1000 on a combination of SageKey scripts and the Wise Installer
package. Eventually I'll manage to wade through it. In the mean time,
I need a quick, "down and dirty" install builder that I can use to
whip together an installer for JUST Access 2003 Runtime. Perhaps this
is the one.
On 2 Feb 2006 17:01:45 -0800, "Alexey Gousev" <al****@gmail.com>
wrote:
Lauren Wilson wrote:
I have a desperate short term need for a way to install Access 2003 runtime on client
computers.
I cannot use the MS Package & Deployment wizard because it won't allow us to install our
app into the specific path that it must be in. It only seems to allow preset macros to define
the target install path -- none of which will work for our app.
The short term solution is simply to install Access 2003 Runtime with a separate install
package.


Lauren, I recommend Agentix Installer: http://www.aginstaller.com
for building install package for the runtime.

It allows you to choose the specific path where your application should
be installed, works on all versions of Windows, creates a single-exe
setups, supports multilingual installations and has a complete set of
the gentleman's features - shortcuts creation, creation of registry and
.INI entries and more. It has it's own scripting mechanism, but it's
more easy to learn and use.

It is very impressive, doing almost everything Inno Setup does, but
producing setup files 250-290Kb smaller because of the very low (48Kb
only) overhead. It is not free, but is reasonably priced.

Feb 3 '06 #9

Never mind. I figured it out.
On Thu, 02 Feb 2006 19:38:39 -0600, Lauren Wilson <no****@nospam.com>
wrote:
Thanks Alexey! I'll check it out. We actually already spent about
$1000 on a combination of SageKey scripts and the Wise Installer
package. Eventually I'll manage to wade through it. In the mean time,
I need a quick, "down and dirty" install builder that I can use to
whip together an installer for JUST Access 2003 Runtime. Perhaps this
is the one.
On 2 Feb 2006 17:01:45 -0800, "Alexey Gousev" <al****@gmail.com>
wrote:
Lauren Wilson wrote:
I have a desperate short term need for a way to install Access 2003 runtime on client
computers.
I cannot use the MS Package & Deployment wizard because it won't allow us to install our
app into the specific path that it must be in. It only seems to allow preset macros to define
the target install path -- none of which will work for our app.
The short term solution is simply to install Access 2003 Runtime with a separate install
package.


Lauren, I recommend Agentix Installer: http://www.aginstaller.com
for building install package for the runtime.

It allows you to choose the specific path where your application should
be installed, works on all versions of Windows, creates a single-exe
setups, supports multilingual installations and has a complete set of
the gentleman's features - shortcuts creation, creation of registry and
.INI entries and more. It has it's own scripting mechanism, but it's
more easy to learn and use.

It is very impressive, doing almost everything Inno Setup does, but
producing setup files 250-290Kb smaller because of the very low (48Kb
only) overhead. It is not free, but is reasonably priced.

Feb 3 '06 #10
Lauren Wilson wrote:
Thanks Alexey! I'll check it out.
In the mean time, I need a quick, "down and dirty" install builder that I can use to
whip together an installer for JUST Access 2003 Runtime. Perhaps this
is the one.


If you need a help of creating a setup script for the Access 2003
Runtime installer feel free to contact me.

Feb 3 '06 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Arun Bhalla | last post by:
I'm working with VS.NET 2003 and .NET 1.1 (not SP1) on Windows XP SP1. My application is using the Windows Installer Bootstrap. (I may have also installed a module which detects requirements (.NET...
121
by: David Pendrey | last post by:
I was wondering if it is at all posible to write a stand alone .EXE program in Visual Studio .NET. Hopefully in VB.NET but if not another language would be ok. Thanks for the assistance
1
by: Ted Sung | last post by:
Hi, We are moving to using mysql as our db and we have some reports already written in Access. Is there a way to create a stand alone EXE that will run the report from Access and then use a DSN...
1
by: Brenda | last post by:
I have an access database that I would like to sell and have it be a stand alone product. I am unsure what the best way to lock someone out of the tables and queries, and make it able to run if...
2
by: Lauren Wilson | last post by:
Hi folks, I am confused about how to create a stand alone installer to install Access 2003 Runtime. There are two files I have compiled into a self-extracting zip file: ACCESSRT.CAB...
6
by: Ryan Bounds | last post by:
Hi All We have upgraded from Access2000 to Access2003 with all service packs. The problem that we have is: When a user try's to filter a client the database crashes and close's Access2003,...
7
by: Ulrich Wisser | last post by:
Hi, I would like to stop the postmaster every night and run vacuum pg_dump reindex in the stand alone backend.
11
by: pg | last post by:
My old HD crashes, so I had to do a total re-install. After installer XP, I went to the Micrsoft Update site to get all the update. After 5 hours or so ... the update cycle started looping. ...
0
by: Rina0 | last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.