By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 2,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Distributing an Access 03 app as runtime

P: n/a
I'm confused about what is necessary to distribute an Access 2003
application to people that don't have MS Access (or don't have the
right version) installed on their PCs. I have done some research on
the MS website, as well as on this newsgroup, and have never found a
clear explanation of what is required.

I have written an application that I would like to sell, but if I can
only sell to those with access to Access (sorry, couldn't resist) I
will be severely limiting my target audience. I would, therefore, like
to be able to provide a executable single file that contains (or
installs) everything necessary to run the app, regardless of the
software installed on the customer's machine. I do not expect to
sell enough copies of the application to warrant a large investment in
tools, so I am hoping that I don't have to buy a very expensive
development kit.

I currently have Access 2003 SP2, installed as part of "Office
Professional Edition 2003."

I would appreciate an advice or information available. Thanks,

Dan

Jun 4 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a

<wa******@twcny.rr.com> wrote in message
news:11********************@g10g2000cwb.googlegrou ps.com...
I'm confused about what is necessary to distribute an Access 2003
application to people that don't have MS Access (or don't have the
right version) installed on their PCs. I have done some research on
the MS website, as well as on this newsgroup, and have never found a
clear explanation of what is required.

I have written an application that I would like to sell, but if I can
only sell to those with access to Access (sorry, couldn't resist) I
will be severely limiting my target audience. I would, therefore, like
to be able to provide a executable single file that contains (or
installs) everything necessary to run the app, regardless of the
software installed on the customer's machine. I do not expect to
sell enough copies of the application to warrant a large investment in
tools, so I am hoping that I don't have to buy a very expensive
development kit.

I currently have Access 2003 SP2, installed as part of "Office
Professional Edition 2003."

I would appreciate an advice or information available. Thanks,

Dan


Sagekey do an installer, I use the MSI 2000 Wizard myself and it works
pretty well.

www.sagekey.com

It costs $425 - I think you need Office Professional which you have covered
so that should be it.
Jun 4 '06 #2

P: n/a
To the best of my knowledge, Sagekey provides scripts (or coding) that works
with other vendors' installers.

To legally distribute a runtime, you need to license the "Visual Studio
Tools for Office 2003 System". Many, in addition to that, find it useful to
use the Wise, InstallShield, or other vendors' installers, along with
SageKey scripts. All together, that is not an inexpensive item, so you'd be
advised to investigate using the Visual Studio Tools first, since you'll
have to have that for the license to distribute the runtime for Access 2003,
no matter if you use someone else's installer.

http://office.microsoft.com/en-us/as...208861033.aspx gives
information on the subject "Obtain and deploy the Access 2003 runtime".

And, just for the record, http://office.microsoft.com is Microsoft's main
online site for Office, including Access, and it is chock-full of good
information.

Larry Linson
Microsoft Access MVP

"Deano" <de***@mailinator.com> wrote in message
news:44***********************@ptn-nntp-reader01.plus.net...

<wa******@twcny.rr.com> wrote in message
news:11********************@g10g2000cwb.googlegrou ps.com...
I'm confused about what is necessary to distribute an Access 2003
application to people that don't have MS Access (or don't have the
right version) installed on their PCs. I have done some research on
the MS website, as well as on this newsgroup, and have never found a
clear explanation of what is required.

I have written an application that I would like to sell, but if I can
only sell to those with access to Access (sorry, couldn't resist) I
will be severely limiting my target audience. I would, therefore, like
to be able to provide a executable single file that contains (or
installs) everything necessary to run the app, regardless of the
software installed on the customer's machine. I do not expect to
sell enough copies of the application to warrant a large investment in
tools, so I am hoping that I don't have to buy a very expensive
development kit.

I currently have Access 2003 SP2, installed as part of "Office
Professional Edition 2003."

I would appreciate an advice or information available. Thanks,

Dan


Sagekey do an installer, I use the MSI 2000 Wizard myself and it works
pretty well.

www.sagekey.com

It costs $425 - I think you need Office Professional which you have
covered
so that should be it.

Jun 5 '06 #3

P: n/a
Larry and Deano,

Ouch, now we're getting pricy. According to the MS website, the
"Visual Studio 2005 Tools for Office" cost $799, with Sagekey running
another $425. I realize Sagekey is an optional product, available to
make the packaging job easier, but even without that, the $799 price
tag seems high for what I'm trying to accomplish. Is there really no
cheaper way to do this legally?

Thanks,

Dan
Larry Linson wrote:
To the best of my knowledge, Sagekey provides scripts (or coding) that works
with other vendors' installers.

To legally distribute a runtime, you need to license the "Visual Studio
Tools for Office 2003 System". Many, in addition to that, find it useful to
use the Wise, InstallShield, or other vendors' installers, along with
SageKey scripts. All together, that is not an inexpensive item, so you'd be
advised to investigate using the Visual Studio Tools first, since you'll
have to have that for the license to distribute the runtime for Access 2003,
no matter if you use someone else's installer.

http://office.microsoft.com/en-us/as...208861033.aspx gives
information on the subject "Obtain and deploy the Access 2003 runtime".

And, just for the record, http://office.microsoft.com is Microsoft's main
online site for Office, including Access, and it is chock-full of good
information.

Larry Linson
Microsoft Access MVP

"Deano" <de***@mailinator.com> wrote in message
news:44***********************@ptn-nntp-reader01.plus.net...

<wa******@twcny.rr.com> wrote in message
news:11********************@g10g2000cwb.googlegrou ps.com...
I'm confused about what is necessary to distribute an Access 2003
application to people that don't have MS Access (or don't have the
right version) installed on their PCs. I have done some research on
the MS website, as well as on this newsgroup, and have never found a
clear explanation of what is required.

I have written an application that I would like to sell, but if I can
only sell to those with access to Access (sorry, couldn't resist) I
will be severely limiting my target audience. I would, therefore, like
to be able to provide a executable single file that contains (or
installs) everything necessary to run the app, regardless of the
software installed on the customer's machine. I do not expect to
sell enough copies of the application to warrant a large investment in
tools, so I am hoping that I don't have to buy a very expensive
development kit.

I currently have Access 2003 SP2, installed as part of "Office
Professional Edition 2003."

I would appreciate an advice or information available. Thanks,

Dan


Sagekey do an installer, I use the MSI 2000 Wizard myself and it works
pretty well.

www.sagekey.com

It costs $425 - I think you need Office Professional which you have
covered
so that should be it.


Jun 5 '06 #4

P: n/a

<wa******@twcny.rr.com> wrote in message
news:11**********************@f6g2000cwb.googlegro ups.com...
Larry and Deano,

Ouch, now we're getting pricy. According to the MS website, the
"Visual Studio 2005 Tools for Office" cost $799, with Sagekey running
another $425. I realize Sagekey is an optional product, available to
make the packaging job easier, but even without that, the $799 price
tag seems high for what I'm trying to accomplish. Is there really no
cheaper way to do this legally?


I'm not a lawyer, but as far as I know, Visual Studio 2003 Tools for Office
2003 System and Visual Studio 2005 Tools for Office are the only way you can
get a license to distribute the Access 2003 runtime. You might look into
various retail discounters.

If you are willing to go with a back version, you can probably buy the
Developer Edition of Office XP or Office 2000 for less at online auction
sites and old software sites. I won't even mention Office 97 Developer
Edition -- it was so much in demand for so long, that finding a copy at any
price might be a challenge. Some years (at least 5) a friend and client of
mine had to have a copy of O97DE. He bought it on eBay, still in shrink
wrap. His comment to me was, "You just don't want to know how much I had to
pay for this."

Whatever approach you use to getting the runtime, be sure to check for
updates to your version.

Larry Linson
Microsoft Access MVP

Jun 6 '06 #5

P: n/a

<wa******@twcny.rr.com> wrote in message
news:11**********************@f6g2000cwb.googlegro ups.com...
Larry and Deano,

Ouch, now we're getting pricy. According to the MS website, the
"Visual Studio 2005 Tools for Office" cost $799, with Sagekey running
another $425. I realize Sagekey is an optional product, available to
make the packaging job easier, but even without that, the $799 price
tag seems high for what I'm trying to accomplish. Is there really no
cheaper way to do this legally?


It cost me alot as well but I regard it as an investment for the future.
Larry's advice about going with an older version of the toolset is a sound
one in my opinion.

The problem is that Sagekey's product is needed because Microsoft' Packaging
and Deployment is less than robust and if you have clients you just want the
damn thing to work.

Having said that I know of a company in my sector that knocked out a (poorly
coded) Access 97 app and they simply stated that 97 was the requirement.
This caused problems when everyone got upgraded to 2000 and Access 97 had to
stay, which as I know from experience can cause conflicts.

I think you have to ask yourself what the likely market is for your app and
be realistic. If it's good and the feedback is positive then the way
forward is to invest the money though what pricing you adopt is important as
well. You could also try to quantify the time, money and general hassle
saved by being able to deploy efficiently - it's paid off me certainly.

The one thing I would say about Sagekey is that they haven't built up a
community - there's no forum on their site for example. As such I haven't
talked to anyone else who uses the same product which is a pity.
Jun 6 '06 #6

P: n/a
Hi,
Deano wrote:
Larry's advice about going with an older version of the toolset is a sound
one in my opinion.

I write small customized software for invoicing, stock etc. using
Access 2000 Professional and VB.NET. I ship my database as an Access
2000 mdb file. I have my customers download the MDAC file available for
download from Microsoft. I do not use Access Reports and since the
applications are not huge, I use the mdb file only for storing data. I
make reports using a third party tool and some custom coding.

Is there a better way apart from purchasing Office Developer Edition or
MS VS Tools for Office? Or, as it is, I do not violate any license? (I
think not and that is why I am at peace with myself on this matter)

Like, for example, is there some way of invoking reports or Access
Forms from Access 2000 _without_ using the Access 2000 dll?

TIA,
JS

Jun 7 '06 #7

P: n/a
Joseph S. wrote:
Hi,
Deano wrote:
Larry's advice about going with an older version of the toolset is a
sound one in my opinion.

I write small customized software for invoicing, stock etc. using
Access 2000 Professional and VB.NET. I ship my database as an Access
2000 mdb file. I have my customers download the MDAC file available
for download from Microsoft. I do not use Access Reports and since the
applications are not huge, I use the mdb file only for storing data. I
make reports using a third party tool and some custom coding.

Is there a better way apart from purchasing Office Developer Edition
or MS VS Tools for Office? Or, as it is, I do not violate any
license? (I think not and that is why I am at peace with myself on
this matter)

Like, for example, is there some way of invoking reports or Access
Forms from Access 2000 _without_ using the Access 2000 dll?

TIA,
JS


You only need the dev tools to obtain a license to distribute Access (the
program). You don't need anything to distribute an MDB file as you are
doing.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jun 7 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.