Executing access files without access program

[Guest]

How could i execute an access file on a system that does
not have an access program installed ?

 

[Ed Robichaud]

This question is frequently asked and answered here.

There is an Access runtime, available only in the older Developer Editions
and now in Visual Studio packages. When combined with an install package it
will give (non-Access installed) users the basic interface EXE and DLL's to
run Access databases.

But considering the cost and install size, you might be better off just
buying users the $99 Access upgrade.

-Ed

 

[Guest]

How could i execute an access file on a system that does
not have an access program installed ?

If all you want to do is view the data in the tables etc., you can open the
database with Excel.

 

[John Vinson]

How could i execute an access file on a system that does
not have an access program installed ?

You cannot.

You'll need to either purchase Access for each user; or purchase a
single copy of the appropriate Access Developer's Edition, currently
called something like Visual Studio Office Tools. This lets you create
royalty-free Access "Runtime" versions of msaccess.exe, which can be
distributed to users. They can use an existing database but have no
design tools included.

Or, you can store the data in an Access .mdb file and use Visual
Basic, Visual C++ or a variety or other programs to design a user
interface from scratch. Budget about twice as much time as you'ld need
for a similar Access frontend (assuming equal skill levels in the
programming environment and Access).

Or, finally, use VBScript to write a Web interface to the data.

John W. Vinson[MVP]

 

[nChicago]

John,
How much does the Visual Studio Office Tools run for?
Does it require any other development tools, like Visual Studio?

Thanks.

N

 

[Jeff Conrad]

in message:

How much does the Visual Studio Office Tools run for?
Does it require any other development tools, like Visual Studio?

This link should provide all the information you need:

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

 

[nChicago]

It looks like $500 to buy a new copy of the Office Developers Tools which
include the access 2003 extensions.

Is it true that you don't need Visual Studio? Would that impinge any
fuctionality?

Thanks.

N

 

[Jeff Conrad]

in message:

It looks like $500 to buy a new copy of the Office Developers Tools which
include the access 2003 extensions.

Is it true that you don't need Visual Studio? Would that impinge any
fuctionality?

Here is a past post by MVP Doug Steele on this question:AFAIK, you only need the following in order to create an Access 2003 runtime
application:

- Microsoft Access 2003
- Visual Studio Tools for Office 2003 (which includes the Access 2003
Developer Extensions)

The ADE is the product that gives you the license to deploy the 2003 runtime
components and you have to have Access 2003 installed in order to install
the ADE.
[/QUOTE][/QUOTE][/QUOTE]