creating "executable" database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are running Access2000. I would like to know, if it possible to create an "executable" version of a access database. I explain better. I know it exists the runtime version of Access. I don't know what should I do in order to let my database being used on a PC where only Access runtime is installed
Is there any documentation on the matter. Which keyword should I use to retrieve information on the web
Thanks in Advanc
Marilla Ferrari
 
HI MArilla!

NO!
You wont be able to create or simulate and Executable of
your Access 2000 application, onless you have a copy of
Access 2000 Developer on your machine.


Plus,I don't belive that a PC will only have a copy of
Access run time installed on-it at any time.(Correct me if
I'm wrong). Onless you mean that that PC has Access
installed onto-it.???

ELSE,
I see 2 ways of achiving what I think you want:
If you develop an application using Access, For it to work
on any given PC's, you will need one of the 2 following
setups, otherwise it won't work.

1- To have a copy of Access installed on every PC's you
want your application copied to.

Or

2- To create an executable(Access Developer)
which in turn, will allow you to install your copy of your
application on any PC's regardless if they have Access or
not installed on their computer.

The "Access runtime"" only comes with versions of Access
Developer. Its the only way to create an application that
will run on its own.

Hope this is what you needed,
PAtrick
-----Original Message-----
We are running Access2000. I would like to know, if it
Click to expand...
possible to create an "executable" version of a access
database. I explain better. I know it exists the runtime
version of Access. I don't know what should I do in order
to let my database being used on a PC where only Access
runtime is installed.
Is there any documentation on the matter. Which keyword
Click to expand...
should I use to retrieve information on the web?
 
(snip)
Plus,I don't belive that a PC will only have a copy of
Access run time installed on-it at any time.(Correct me if
I'm wrong). Onless you mean that that PC has Access
installed onto-it.???
Click to expand...

Access has a so-called "runtime" version (as you clearly know already). It
is quite possible that one PC has a full version of Access, another has just
the runtime version, and a third one does not have any version at all. The
first 2 of those 3 PCs, >do have Access on them<. The third one doesn't.
Either of the first two PCs could probably run the original poster's
database. The third one couldn't.

2- To create an executable(Access Developer)
which in turn, will allow you to install your copy of your
application on any PC's regardless if they have Access or
not installed on their computer.
Click to expand...

The developer runtime version >is a version of Access<. If you have the
runtime on your PC, you do have Access on your PC. Again, there is the full
(retail) version of Access, and the runtime (developer) version of Access.
Both of those are versions of Access.

HTH,
TC
 
Marilla said:
We are running Access2000. I would like to know, if it possible to
create an "executable" version of a access database. I explain
better. I know it exists the runtime version of Access. I don't know
what should I do in order to let my database being used on a PC
where only Access runtime is installed. Is there any documentation on
the matter. Which keyword should I use to retrieve information on the
web?
Thanks in Advance
Marilla Ferrari
Click to expand...

You cannot convert your database into an executable that will run on a
computer that has neither full Access nor the run-time version of Access
installed. However, if the target computer has at least the run-time
version of Access installed on it, your database will be able to run.
If the target computer has only the Access run-time, then as I
understand it (not having done this myself) you must create your own
menus and toolbars in the database, because the menus provided by the
full version of Access won't be available.

If you need to be able to create an install package that will install
your database *and* the Access run-time on a target computer that
doesn't already have Access on it, then you must purchase the Access
2000 or 2002 Developer Edition, which includes the Access run-time, a
license to distribute it, and a Packaging Wizard to build your install
package. The Packaging Wizard is not perfect, I'm told, and many
developers also buy third-party tools to help with this. Tony Toews has
a page describing some of the problems, with links to companies that
provide such tools:

http://www.granite.ab.ca/access/runtime.htm

You may have difficulty finding the Developer edition for Access 2000 or
2002, because these products (esp. Access 2000) are now considered out
of date. It's certainly worth looking on eBay or other such resale
sites. Or you could buy the Office 2003 equivalent, which is sold
separately as the combination of Access 2003 and what I *think* is
called the "Visual Studio Tools for Office 2003" or something like that.
 
Visual studio for Office 2003, is an alternative to Access developper or both must be on the "develooper" computer?
Will I have problem in using Visual studio for Office2003 if I have Office 2000 installed?
Does anybody know if there's a Microsoft phone number to ask this kind of informations?
Marilla Ferrari

----- Dirk Goldgar wrote: -----

Marilla said:
We are running Access2000. I would like to know, if it possible to
create an "executable" version of a access database. I explain
better. I know it exists the runtime version of Access. I don't know
what should I do in order to let my database being used on a PC
where only Access runtime is installed. Is there any documentation on
the matter. Which keyword should I use to retrieve information on the
web?
Thanks in Advance
Marilla Ferrari
Click to expand...

You cannot convert your database into an executable that will run on a
computer that has neither full Access nor the run-time version of Access
installed. However, if the target computer has at least the run-time
version of Access installed on it, your database will be able to run.
If the target computer has only the Access run-time, then as I
understand it (not having done this myself) you must create your own
menus and toolbars in the database, because the menus provided by the
full version of Access won't be available.

If you need to be able to create an install package that will install
your database *and* the Access run-time on a target computer that
doesn't already have Access on it, then you must purchase the Access
2000 or 2002 Developer Edition, which includes the Access run-time, a
license to distribute it, and a Packaging Wizard to build your install
package. The Packaging Wizard is not perfect, I'm told, and many
developers also buy third-party tools to help with this. Tony Toews has
a page describing some of the problems, with links to companies that
provide such tools:

http://www.granite.ab.ca/access/runtime.htm

You may have difficulty finding the Developer edition for Access 2000 or
2002, because these products (esp. Access 2000) are now considered out
of date. It's certainly worth looking on eBay or other such resale
sites. Or you could buy the Office 2003 equivalent, which is sold
separately as the combination of Access 2003 and what I *think* is
called the "Visual Studio Tools for Office 2003" or something like that.
 
Visual studio for Office 2003, is an alternative to Access developper or both must be on the "develooper" computer?
Click to expand...

Visual Studio for Office is just tne new name for "Access Developer".
Microsoft keeps changing the name of the program.
Will I have problem in using Visual studio for Office2003 if I have Office 2000 installed?
Click to expand...

Just install them to different directories. You can search the
Knowledge Base at http://support.microsoft.com; there are thousands of
articles about all sorts of issues, including the precautions needed
when running different versions of Access.
Does anybody know if there's a Microsoft phone number to ask this kind of informations?
Click to expand...

Telephone tech support is a for-fee service, I believe $45 per call;
I'd suggest that these newsgroups may provide comprable or better
support, and the price can't be beat!
 
Marilla said:
Visual studio for Office 2003, is an alternative to Access developper
or both must be on the "develooper" computer? Will I have problem in
using Visual studio for Office2003 if I have Office 2000 installed?
Does anybody know if there's a Microsoft phone number to ask this
kind of informations?
Click to expand...

Marilla -

I have no personal knowledge or familarity with Office 2003 or Visual
Studio Tools for Office 2003 (VSTO), but here are the best answers I can
give to your questions:

+ For Access 2003, VSTO *replaces* the "Developer Edition" of previous
versions of Access. In other words, there is no "Office 2003 Developer
Edition", just VSTO, purchased separately from your copy of Access 2003.

+ You can't use VSTO without Access 2003 installed on your system.

+ I don't think you can use VSTO to package an Access 2000 application,
without first converting the database to Access 2003 format. I could be
wrong about this, though. If A2K3 is like A2K and A2K2, you can't
convert your database to an MDE (stripping out the source code and
design elements) without first converting it to Access 2003 format.

+ You *can* install both Access 2003 and and Access 2000 on the same
system, provided you do it carefully, installing them in separate
folders and (ideally) in the correct order: A2K first, then A2K3. So I
assume that, with both A2K and A2K3 installed, you can install VSTO and
use it on an A2K3-format database.

+ Simplest for you, if you want to avoid upgrading to Access 2003 and
buying VSTO, would be to search for a copy of the Office 2000 Developer
Edition being offered for sale somewhere.

+ I'm sorry, I don't know of any phone number you can call at Microsoft
to get answers to questions like these. I had to use Google Groups
(http://groups.google.com) to search the archives of the Access
newsgroups for some of the answers above. It may be that you'll find
some of the information on the Microsoft Office web site
(http://office.microsoft.com), but it's not readily apparent to me where
such information might be.
 
Back
Top