We help IT Professionals succeed at work.

Runtime - Office Access 2003 Developer Extenstions

Alaska Cowboy
on
Medium Priority
481 Views
Last Modified: 2009-12-16
I am investigating creating a runtime version to send out with my MDE.

I installed MS Office access 2003 Developer Extensions, but I don't know what that is. The install seemed successful.

In a VBA module, I clicked on Add-In Manager, but it's blank.

How do you create a runtime?
Comment
Watch Question

Database Developer
CERTIFIED EXPERT
Commented:
It's an installed application - Start Menu > Programs > access 2003 Developer Extensions > package wizard

It uses Access to run - but runs separately from your own applications

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Ok, I see that, thanks.

I tried to do a few things in it, but got an error: "Run-time error 31521: Cannot establish connection to the server."

Any ideas?
Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
At what stage?
What kind of database is it you're packaging?

Author

Commented:
Just when opening, but it seemed like a clean installation.

I start it up, choose "NWINDCST" as the template. If I then choose "Run" or "Next", I get the error.

This happens for Startup or Package.

???
Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
You're wanting to create your own new package - rather than be based on a template.
But if you're still getting errors then perhaps it needs to be re-installed.

Author

Commented:
Ok, I started my own work.

I ran into a few problems on the Startup Wizard, will give more details tonight.

The package wizard was looking good - no issues.

The developer extensions is pretty slick . . . thanks

Author

Commented:
LPurvis,

I'm trying a startup wizard. On the second page it asks to "set startup properties". I check yes, click the button then get an error "The command or action 'StartupProperties' isn't available now". In my application I took out the startup form.

The it says
*You may be in a read-only d.b. or an uncoverted d.b from an earlier version of [my system].
*The type of object the action applies to isn't currently selected or isn't in the active view"

Any idea?

Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
What are you wanting to achieve using the Startup Wizard?

It doesn't really do much for me personally (I prefer to do such things manually).

Author

Commented:
Just investigating, it looked helpful (and of course professional). One of the things was to remove VBA code, "equivalent to MDE" it says. It also had an option to "Allow Bypass Key" - that seems good to have.

Sounds like you can do the same things yourself . . .
Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
Yep. :-)

("equivalent to make MDE" = make an mde)
-------------------^

Author

Commented:
ok, got it.

How about the Package Installer?
Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
Very different.
Not reproducable otherwise (unless of course with a different install package like SageKey or Installshield)
It's what the Developer edition is mainly about (that and the royalty free runtime licence ;-)

Author

Commented:
do you use it?
Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
Yes.
When required.
(Since 97 - and have found it very reasonable for the most part.)

Author

Commented:
thanks a lot.

Author

Commented:
If you're still there, I created a package.

Then I zipped everything up -

The cab file is 34mb - what's up with that?

I put in two files
- my application (~4mb)
- documentation (~1mb)
Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
The rest of it is Access!  :-)
Creating the runtime version installs a version of Access on users machines than can only be used in runtime mode.
(Or if they have Access already - allows it to be *run* in runtime mode).

But Access itself and its components are all required (with a select few features not available of course).

That's what's required.
34MB is about as small as you'll get it.

Author

Commented:
I didn't think about that  . . . I kept thinking I'd have this small little package to send out, 2 to 4 mb.

Makes it a bit hard to e-mail to people, now I need a ftp site or something . . .

thanks for the followup.
Leigh PurvisDatabase Developer
CERTIFIED EXPERT

Commented:
No probs.
You can always offer either...
An install for people who already have Access - and one with the runtime.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.