Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / May 2005

Tip: Looking for answers? Try searching our database.

Executing access files without access program

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JOo. - 23 May 2005 00:59 GMT
How could i execute an access file on a system that does
not have an access program installed ?
Ed Robichaud - 23 May 2005 01:50 GMT
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

> How could i execute an access file on a system that does
> not have an access program installed ?
Paul - 23 May 2005 03:22 GMT
> 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 - 23 May 2005 03:31 GMT
>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 - 23 May 2005 05:39 GMT
John,
How much does the Visual Studio Office Tools run for?
Does it require any other development tools, like Visual Studio?

Thanks.

N

>>How could i execute an access file on a system that does
>>not have an access program installed ?
[quoted text clipped - 17 lines]
>
>                  John W. Vinson[MVP]
Jeff Conrad - 23 May 2005 05:53 GMT
> 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

Signature

Jeff Conrad
Access Junkie
Bend, Oregon

nChicago - 23 May 2005 06:26 GMT
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

>> 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
Jeff Conrad - 23 May 2005 06:43 GMT
> 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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele

>>>>>>
Signature

Jeff Conrad
Access Junkie
Bend, Oregon

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.