This is a multi-part message in MIME format.

------=_NextPart_000_0104_01C1EBEA.76990920
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi everyone.

I have designed and constructed a database (Access 2000) to hold all the 
details of our pupils and teachers activities. (I work in music 
education).

I would like to be able to issue a small database to each teacher so 
that they can do their own data updates.  These can then be uploaded in 
to the main database.

I have constructed the database and made it an mde file, but this still 
requires Access to be present on the users machine in order to run.
Is it possible to make it into a completely stand alone fiel which will 
run withoutnAccess?  If so could some one explain the procedure to me in 
words of one syllable!  I have the Office developer Toolkit if thats any 
use.

Thanks, Wes Kendrick

"in words of one syllable"...That's tough. No. But per the MicroSoft
pdwiz.html and I quote

To package and deploy Office solutions created using Microsoft® Office
2000 Developer, you must launch the VBA Package and Deployment wizard
from within the VBA solution project, so all dependencies can be
identified. 

The Package and Deployment wizard makes it easier for you to build and
to deploy setup programs for your Office 2000 solutions. The wizard
guides you through the steps of creating .cab files for your solution,
grouping them into a unit, or package, that contains all of the
information required for installation, and delivering those packages to
users. 

To package and deploy your solution using the wizard

Open your project in the Microsoft® Visual Basic® Editor (Alt+F11). 
From the Add-ins menu, select the VBA Package and Deployment wizard. 
If the Package and Deployment wizard is not available from the Add-ins
menu, select the Add-in Manager, and then select the Package and
Deployment wizard add-in to load on startup. 



--- Wesley Kendrick <wez.k@n...> wrote:
> Hi everyone.
> 
> I have designed and constructed a database (Access 2000) to hold all
> the details of our pupils and teachers activities. (I work in music
> education).
> 
> I would like to be able to issue a small database to each teacher so
> that they can do their own data updates.  These can then be uploaded
> in to the main database.
> 
> I have constructed the database and made it an mde file, but this
> still requires Access to be present on the users machine in order to
> run.
> Is it possible to make it into a completely stand alone fiel which
> will run withoutnAccess?  If so could some one explain the procedure
> to me in words of one syllable!  I have the Office developer Toolkit
> if thats any use.
> 
> Thanks, Wes Kendrick
> 
> 
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/

This is all true but it still doesn't allow you to distribute your
application without access runtime.  To run an access application you 
will
need access runtime installed on the machine.

If you wrote your application in Visual Basic - not VB for Application 
like
is used in Access (or Excel etc) but in full-blown VB, then you could 
have a
"standalone" application (that is, you wouldn't need a licensed product 
to
run it with). But Access R/T is free to distribute, and the P&D Wizard 
will
package it in with your app.


-----Original Message-----
From: Tad Groves [mailto:tegrovesjr@r...]
Sent: Wednesday, April 24, 2002 7:04 PM
To: Access
Subject: [access] Re: stand alone executables


"in words of one syllable"...That's tough. No. But per the MicroSoft
pdwiz.html and I quote

To package and deploy Office solutions created using Microsoft=AE 
Office
2000 Developer, you must launch the VBA Package and Deployment wizard
from within the VBA solution project, so all dependencies can be
identified.

The Package and Deployment wizard makes it easier for you to build and
to deploy setup programs for your Office 2000 solutions. The wizard
guides you through the steps of creating .cab files for your solution,
grouping them into a unit, or package, that contains all of the
information required for installation, and delivering those packages to
users.

To package and deploy your solution using the wizard

Open your project in the Microsoft=AE Visual Basic=AE Editor (Alt+F11). 

From the Add-ins menu, select the VBA Package and Deployment wizard.
If the Package and Deployment wizard is not available from the Add-ins
menu, select the Add-in Manager, and then select the Package and
Deployment wizard add-in to load on startup.



--- Wesley Kendrick <wez.k@n...> wrote:
> Hi everyone.
>
> I have designed and constructed a database (Access 2000) to hold all
> the details of our pupils and teachers activities. (I work in music
> education).
>
> I would like to be able to issue a small database to each teacher so
> that they can do their own data updates.  These can then be uploaded
> in to the main database.
>
> I have constructed the database and made it an mde file, but this
> still requires Access to be present on the users machine in order to
> run.
> Is it possible to make it into a completely stand alone fiel which
> will run withoutnAccess?  If so could some one explain the procedure
> to me in words of one syllable!  I have the Office developer Toolkit
> if thats any use.
>
> Thanks, Wes Kendrick
>
>
>


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/

Is there a P&D wizard or something comparable for Access 97. I couldn't find
it in the access help

What do I do if there isn't?

thanks,

Barry


----- Original Message -----
From: "Carnley, Dave" <dcarnley@a...>
To: "Access" <access@p...>
Sent: Thursday, April 25, 2002 10:01 AM
Subject: [access] Re: stand alone executables


This is all true but it still doesn't allow you to distribute your
application without access runtime.  To run an access application you will
need access runtime installed on the machine.

If you wrote your application in Visual Basic - not VB for Application like
is used in Access (or Excel etc) but in full-blown VB, then you could have a
"standalone" application (that is, you wouldn't need a licensed product to
run it with). But Access R/T is free to distribute, and the P&D Wizard will
package it in with your app.


-----Original Message-----
From: Tad Groves [mailto:tegrovesjr@r...]
Sent: Wednesday, April 24, 2002 7:04 PM
To: Access
Subject: [access] Re: stand alone executables


"in words of one syllable"...That's tough. No. But per the MicroSoft
pdwiz.html and I quote

To package and deploy Office solutions created using Microsoft® Office
2000 Developer, you must launch the VBA Package and Deployment wizard
from within the VBA solution project, so all dependencies can be
identified.

The Package and Deployment wizard makes it easier for you to build and
to deploy setup programs for your Office 2000 solutions. The wizard
guides you through the steps of creating .cab files for your solution,
grouping them into a unit, or package, that contains all of the
information required for installation, and delivering those packages to
users.

To package and deploy your solution using the wizard

Open your project in the Microsoft® Visual Basic® Editor (Alt+F11).
From the Add-ins menu, select the VBA Package and Deployment wizard.
If the Package and Deployment wizard is not available from the Add-ins
menu, select the Add-in Manager, and then select the Package and
Deployment wizard add-in to load on startup.



--- Wesley Kendrick <wez.k@n...> wrote:
> Hi everyone.
>
> I have designed and constructed a database (Access 2000) to hold all
> the details of our pupils and teachers activities. (I work in music
> education).
>
> I would like to be able to issue a small database to each teacher so
> that they can do their own data updates.  These can then be uploaded
> in to the main database.
>
> I have constructed the database and made it an mde file, but this
> still requires Access to be present on the users machine in order to
> run.
> Is it possible to make it into a completely stand alone fiel which
> will run withoutnAccess?  If so could some one explain the procedure
> to me in words of one syllable!  I have the Office developer Toolkit
> if thats any use.
>
> Thanks, Wes Kendrick
>
>
>


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/

On Thu, 25 Apr 2002 11:37:05 -0400 Barry Dancis wrote:

> Is there a P&D wizard or something comparable for Access 97. I
> couldn't find it in the access help.

It isn't there. It comes in a box called the Developers' Tool Kit, 
and is an Access application. I think it's called the "Setup Wizard." 
(It took me a while to figure out the Office 2000 way of doing 
things.)


Paul

Including the access runtime is a check box.  With VB you still have a
runtime to distribute as well even though you created an "EXE". 

HTH


--- "Carnley, Dave" <dcarnley@a...> wrote:
> This is all true but it still doesn't allow you to distribute your
> application without access runtime.  To run an access application you
> will
> need access runtime installed on the machine.
> 
> If you wrote your application in Visual Basic - not VB for
> Application like
> is used in Access (or Excel etc) but in full-blown VB, then you could
> have a
> "standalone" application (that is, you wouldn't need a licensed
> product to
> run it with). But Access R/T is free to distribute, and the P&D
> Wizard will
> package it in with your app.
> 
> 
> -----Original Message-----
> From: Tad Groves [mailto:tegrovesjr@r...]
> Sent: Wednesday, April 24, 2002 7:04 PM
> To: Access
> Subject: [access] Re: stand alone executables
> 
> 
> "in words of one syllable"...That's tough. No. But per the MicroSoft
> pdwiz.html and I quote
> 
> To package and deploy Office solutions created using Microsoft®
> Office
> 2000 Developer, you must launch the VBA Package and Deployment wizard
> from within the VBA solution project, so all dependencies can be
> identified. 
> 
> The Package and Deployment wizard makes it easier for you to build
> and
> to deploy setup programs for your Office 2000 solutions. The wizard
> guides you through the steps of creating .cab files for your
> solution,
> grouping them into a unit, or package, that contains all of the
> information required for installation, and delivering those packages
> to
> users. 
> 
> To package and deploy your solution using the wizard
> 
> Open your project in the Microsoft® Visual Basic® Editor (Alt+F11). 
> From the Add-ins menu, select the VBA Package and Deployment wizard. 
> If the Package and Deployment wizard is not available from the
> Add-ins
> menu, select the Add-in Manager, and then select the Package and
> Deployment wizard add-in to load on startup. 
> 
> 
> 
> --- Wesley Kendrick <wez.k@n...> wrote:
> > Hi everyone.
> > 
> > I have designed and constructed a database (Access 2000) to hold
> all
> > the details of our pupils and teachers activities. (I work in music
> > education).
> > 
> > I would like to be able to issue a small database to each teacher
> so
> > that they can do their own data updates.  These can then be
> uploaded
> > in to the main database.
> > 
> > I have constructed the database and made it an mde file, but this
> > still requires Access to be present on the users machine in order
> to
> > run.
> > Is it possible to make it into a completely stand alone fiel which
> > will run withoutnAccess?  If so could some one explain the
> procedure
> > to me in words of one syllable!  I have the Office developer
> Toolkit
> > if thats any use.
> > 
> > Thanks, Wes Kendrick
> > 
> > 
> > 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Games - play chess, backgammon, pool and more
> http://games.yahoo.com/
> 
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/