Runtime - Office Access 2003 Developer Extenstions

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?
LVL 1
Alaska CowboyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Leigh PurvisDatabase DeveloperCommented:
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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Alaska CowboyAuthor 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?
0
Leigh PurvisDatabase DeveloperCommented:
At what stage?
What kind of database is it you're packaging?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Alaska CowboyAuthor 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.

???
0
Leigh PurvisDatabase DeveloperCommented:
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.
0
Alaska CowboyAuthor 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
0
Alaska CowboyAuthor 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?

0
Leigh PurvisDatabase DeveloperCommented:
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).
0
Alaska CowboyAuthor 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 . . .
0
Leigh PurvisDatabase DeveloperCommented:
Yep. :-)

("equivalent to make MDE" = make an mde)
-------------------^
0
Alaska CowboyAuthor Commented:
ok, got it.

How about the Package Installer?
0
Leigh PurvisDatabase DeveloperCommented:
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 ;-)
0
Alaska CowboyAuthor Commented:
do you use it?
0
Leigh PurvisDatabase DeveloperCommented:
Yes.
When required.
(Since 97 - and have found it very reasonable for the most part.)
0
Alaska CowboyAuthor Commented:
thanks a lot.
0
Alaska CowboyAuthor 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)
0
Leigh PurvisDatabase DeveloperCommented:
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.
0
Alaska CowboyAuthor 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.
0
Leigh PurvisDatabase DeveloperCommented:
No probs.
You can always offer either...
An install for people who already have Access - and one with the runtime.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.