?
Solved

Runtime - Office Access 2003 Developer Extenstions

Posted on 2006-03-20
19
Medium Priority
?
460 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?
0
Comment
Question by:Alaska Cowboy
  • 10
  • 9
19 Comments
 
LVL 44

Accepted Solution

by:
Leigh Purvis earned 400 total points
ID: 16243485
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
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 16243548
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
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 16244615
At what stage?
What kind of database is it you're packaging?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 16246024
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
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 16246239
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
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 16246427
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
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 16253089
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
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 16253119
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
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 16253246
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
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 16253285
Yep. :-)

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

Author Comment

by:Alaska Cowboy
ID: 16253292
ok, got it.

How about the Package Installer?
0
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 16253313
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
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 16253319
do you use it?
0
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 16253339
Yes.
When required.
(Since 97 - and have found it very reasonable for the most part.)
0
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 16253345
thanks a lot.
0
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 16253388
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
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 16253397
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
 
LVL 1

Author Comment

by:Alaska Cowboy
ID: 16253747
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
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 16253768
No probs.
You can always offer either...
An install for people who already have Access - and one with the runtime.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question