How to distribute an MS Access 2003 App?

[jackbenimble999]

Hello!

I'd like to distribute an application developed in MS Access 2003.
I've looked at the MS web site and it says although the ability to
distribute is included with MS Office Retail, you still need to
purchase a licence, yet it provides no links.. It also says that you
need developer extensions to package it, but still no link! .Overall,
I'm a bit confused and am wondering if anyone can set me on the right
track.

thanks!\
Jack B. Nimble

[Allen Browne]

Rather than purchase the runtime or Access 2003, would you be better to
upgrade to Access 2007?

That way you can distribute the runtime without having to buy it:
http://www.microsoft.com/downloads/d...displaylang=en

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ja*************@gmail.comwrote in message
news:13**********************************@q77g2000 hsh.googlegroups.com...

>
I'd like to distribute an application developed in MS Access 2003.
I've looked at the MS web site and it says although the ability to
distribute is included with MS Office Retail, you still need to
purchase a licence, yet it provides no links.. It also says that you
need developer extensions to package it, but still no link! .Overall,
I'm a bit confused and am wondering if anyone can set me on the right
track.

thanks!\
Jack B. Nimble

[jackbenimble999]

Dear Allen,

Thank you for the tip! Questions:

Are there likely to be a lot of API changes? I know I ran into some of
that when I upgraded from Access 2.0.

Can I purchase Access 2007 separately from Office 97?

Does it run on XP, or does it need Vista?

Thanks again!

Jack B. Nimble

On Feb 7, 1:15 am, "Allen Browne" <[e-mail]:

Rather than purchase the runtime or Access 2003, would you be better to
upgrade to Access 2007?

That way you can distribute the runtime without having to buy it:
http://www.microsoft.com/downloads/d...d=D9AE78D9-9DC...

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<[e-mail] in message

news:13**********************************@q77g2000 hsh.googlegroups.com...

I'd like to distribute an application developed in MS Access 2003.
I've looked at the MS web site and it says although the ability to
distribute is included with MS Office Retail, you still need to
purchase a licence, yet it provides no links.. It also says that you
need developer extensions to package it, but still no link! .Overall,
I'm a bit confused and am wondering if anyone can set me on the right
track.

thanks!\
Jack B. Nimble

[Allen Browne]

Answers in-line.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ja*************@gmail.comwrote in message
news:45**********************************@u10g2000 prn.googlegroups.com...

Are there likely to be a lot of API changes? I know I ran into some of
that when I upgraded from Access 2.0.

No changes. Access 2 was 16-bit, so you needed to change to 32-bit. A2007 is
still using the 32-bit calls.

Can I purchase Access 2007 separately from Office 97?

Separately from Office 2007? I believe you can.

If you need to, you can run A2007 and A97 on the same machine. (I'm running
those 2 plus A2000, 2002 and 2003 in this machine.)

Does it run on XP, or does it need Vista?

A2007 runs on XP too.

[AllenWhite]

On Feb 7, 11:36*am, [e-mail] wrote:

Dear Allen,

Thank you for the tip! Questions:

Are there likely to be a lot of API changes? I know I ran into some of
that when I upgraded from Access 2.0.

Can I purchase Access 2007 separately from Office 97?

If you have any version of Access from 2000 on, the upgrade version is
only about $125 or so. I think the full version is $240.

[Mark.Fishbaugher]

On Feb 6, 9:05 pm, [e-mail] wrote:

Hello!

I'd like to distribute an application developed in MS Access 2003.
I've looked at the MS web site and it says although the ability to
distribute is included with MS Office Retail, you still need to
purchase a licence, yet it provides no links.. It also says that you
need developer extensions to package it, but still no link! .Overall,
I'm a bit confused and am wondering if anyone can set me on the right
track.

thanks!\
Jack B. Nimble

If you are doing an Access runtime installation, I can recommend the
folks at sagekey.com. I have used their WISE script for AC97 and
AC2002 runtime installations with good success for years. They do the
footwork to handle the possible permutations of other runtimes and
Access versions on the target machine and have scripts for WISE and
and MSI. Here is a link to a discussion about runtimes and versions
that might help.

http://www.sagekey.com/access_runtime_faq.aspx

[jackbenimble999]

Thanks, Allen! I got hold of a version of Access 2007 and have more
question for you!

(I think this is similar to the problem I was having in 2003...)

When I open the database, Access say:

"Security Alert"

VBA Macro

Access has disable potentially harmful content in this databases

(blah..blah..blah..)

Then an option to enable this content - but just for the session.

How do I get rid of this message - permanently?

Many thanks,
Jack B. Nimble

On Feb 7, 11:00 am, "Allen Browne" <[e-mail]:

Answers in-line.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips forAccessusers -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<[e-mail] in message

news:45**********************************@u10g2000 prn.googlegroups.com...

Are there likely to be a lot of API changes? I know I ran into some of
that when I upgraded fromAccess2.0.

No changes.Access2 was 16-bit, so you needed to change to 32-bit. A2007 is
still using the 32-bit calls.

Can I purchaseAccess2007 separately from Office 97?

Separately from Office 2007? I believe you can.

If you need to, you can run A2007 and A97 on the same machine. (I'm running
those 2 plus A2000, 2002 and 2003 in this machine.)

Does it run on XP, or does it need Vista?

A2007 runs on XP too.

[Allen Browne]

Tell A2007 you trust the folder where you place your databases (and
subfolders):
Office Button | Access Options | Trust Center | Trust Center Settings

There's a bunch more help on adapting to A2007 here:
http://allenbrowne.com/Access2007.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ja*************@gmail.comwrote in message
news:e8**********************************@f10g2000 hsf.googlegroups.com...

Thanks, Allen! I got hold of a version of Access 2007 and have more
question for you!

(I think this is similar to the problem I was having in 2003...)

When I open the database, Access say:

"Security Alert"

VBA Macro

Access has disable potentially harmful content in this databases

(blah..blah..blah..)

Then an option to enable this content - but just for the session.

How do I get rid of this message - permanently?

[jackbenimble999]

Allen,

Thanks for your many fine tips! Another questions (of course!).

When I package up the Access application and install and start it,
this same trust message comes up. However, the Office button only
contains a couple of items, neither of which allows the disabling of
this unruly message. Is there a way to remove it from a distributed
application?

Jack B. Nimble

On Feb 9, 1:50 am, "Allen Browne" <[e-mail]:

Tell A2007 you trust the folder where you place your databases (and
subfolders):
Office Button | Access Options | Trust Center | Trust Center Settings

There's a bunch more help on adapting to A2007 here:
http://allenbrowne.com/Access2007.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<[e-mail] in message

news:e8**********************************@f10g2000 hsf.googlegroups.com...

Thanks, Allen! I got hold of a version of Access 2007 and have more
question for you!

(I think this is similar to the problem I was having in 2003...)

When I open the database, Access say:

"Security Alert"

VBA Macro

Access has disable potentially harmful content in this databases

(blah..blah..blah..)

Then an option to enable this content - but just for the session.

How do I get rid of this message - permanently?

[Allen Browne]

Jeff Conrad explains the reg key you need to set:
http://accessjunkie.com/faq_33.aspx

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ja*************@gmail.comwrote in message
news:8a**********************************@s19g2000 prg.googlegroups.com...

Allen,

Thanks for your many fine tips! Another questions (of course!).

When I package up the Access application and install and start it,
this same trust message comes up. However, the Office button only
contains a couple of items, neither of which allows the disabling of
this unruly message. Is there a way to remove it from a distributed
application?

[jackbenimble999]

Allen,

Outstanding tip! I had installed my app/runtime on a Vista machine, so
I changed the registry setting to include the trusted path, and it got
rid of the message! (the one asking if it is ok to run the app despite
an unknown source).

But (there's always something!) the installed app is now having
trouble with the AutoExcec macro, which does a runcode command, error
2950. I think it's a trust issue. Why? Because can repeat this exact
message in my own Access 2007 development environment when I remove my
project from being trusted!

Naturally, I can solve this by re-trusting my project, but it doesn't
fix the problem for the runtime on the Vista.

The strangest thing is that, when I install the app/runtime on my own
XP system (and don't trust the folder), as expected, I get the message
asking if it is ok to run - but when I say ok, the AutoExec macro runs
perfectly!
Thanks!
Jack B. Nimble




On Feb 10, 6:41 pm, "Allen Browne" <[e-mail]:

Jeff Conrad explains the reg key you need to set:
http://accessjunkie.com/faq_33.aspx

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<[e-mail] in message

news:8a**********************************@s19g2000 prg.googlegroups.com...

Allen,

Thanks for your many fine tips! Another questions (of course!).

When I package up the Access application and install and start it,
this same trust message comes up. However, the Office button only
contains a couple of items, neither of which allows the disabling of
this unruly message. Is there a way to remove it from a distributed
application?

[Allen Browne]

An alternative to AutoExec would be to use the Open event of the start up
form.

No promises: depends on timing and what's trusted.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ja*************@gmail.comwrote in message
news:ca**********************************@d21g2000 prf.googlegroups.com...

>
Outstanding tip! I had installed my app/runtime on a Vista machine, so
I changed the registry setting to include the trusted path, and it got
rid of the message! (the one asking if it is ok to run the app despite
an unknown source).

But (there's always something!) the installed app is now having
trouble with the AutoExcec macro, which does a runcode command, error
2950. I think it's a trust issue. Why? Because can repeat this exact
message in my own Access 2007 development environment when I remove my
project from being trusted!

Naturally, I can solve this by re-trusting my project, but it doesn't
fix the problem for the runtime on the Vista.

The strangest thing is that, when I install the app/runtime on my own
XP system (and don't trust the folder), as expected, I get the message
asking if it is ok to run - but when I say ok, the AutoExec macro runs
perfectly!