Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 13th, 2003, 05:49 PM
Authorized User
 
Join Date: Aug 2003
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to huskie
Default Package

    I would like to package a MDB file, it's icon, and it's splash screen. If anyone knows how to package multiple files in a single EXE, please email me at this email address. Also, if I need any extra files too, please email me about that, too!

Thanks!

- MarkSeymour
__________________
- Mark Seymour
 
Old August 13th, 2003, 09:29 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Mark, I don't know if anyone's answered this yet, since you wanted an email (which is why I'm also posting this on the forum), but Winzip can do all that.

You could always shell out the money for the developer tools if you want to package it as a runtime app, but if you're assuming your user has Access, and all the necessary references already, then you can just put the files in a zip, then create a self-extracting EXE, which is fairly easy to use and customize.

Steven

I am a loud man with a very large hat. This means I am in charge
 
Old August 14th, 2003, 08:51 AM
Authorized User
 
Join Date: Aug 2003
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to huskie
Default

Do you know if EnZip will work? becuase I [u]Never</u> use Winzip.

- MarkSeymour
 
Old August 15th, 2003, 12:23 AM
Ash Ash is offline
Registered User
 
Join Date: Aug 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Mark

You could also try using a specialised installation program. There are a number of freeware / shareware products (eg Inno Setup at http://www.jrsoftware.org) as well as the better known commercial products (such as Wise).

You must have a Developer Edition of MS Office to distribute you program as a runtime application. The developer tools supplied with this edition include an installation wizard.

Ashley
 
Old August 16th, 2003, 07:28 PM
Authorized User
 
Join Date: Aug 2003
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to huskie
Default

I can always rename the file extension to .exe, but then it would say that it's not a valid Win32 (Windows 32-bit) application. Any other way?

- MarkSeymour
 
Old August 16th, 2003, 11:51 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Hi Mark,

A little clarification might be warrented here. There are no utilities of any kind, anywhere that will convert an Access .mdb file into an .exe file, i.e. a file that your computer can execute directly, much less one with embedded, compiled dependent files such as graphics.

That's why even if you use the Office Developer Packaging Wizard to deploy your app, the client machines must have either Access already installed, or include the Access run-time with the installation package. In fact, any installation utility that deploys an Access database (Visual Studio Installer, Wise, Installshield, Windows Installer) really only copies the .mdb file and dependent files - as seperate physical files - to specified locations on your file system (the MOD Packaging Wizard, for example, creates a Setup.exe that handles this for you). That means that your .mdb file must maintain pointers, in code or as property settings, to the dependent files (such as the AppIcon property available through the Startup properties dialog, or copying a bitmap to the application directory, or appending file paths as named properties to the properties collection of the database object.)

You can embed image files in your front-end executable by compiling, say, a VB project, but even then the .mdb file exists elsewhere in your file system.

One of the reasons I'm a big fan of .NET deployment is you can build a Windows Installer (.msi) setup program in a matter of minutes that consolidates all of your front-end dependencies and can be simply copied to any client with the .NET Framework installed. Couldn't be easier.

HTH,

Bob



 
Old August 17th, 2003, 01:55 PM
Authorized User
 
Join Date: Aug 2003
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to huskie
Default

Talking about installations, I've been using Inno setup, and works great! But, to do even more customizations, i would have to download DLL's and such. :)

- MarkSeymour
 
Old August 18th, 2003, 06:17 AM
Registered User
 
Join Date: Jun 2003
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Mark,

Would you be willing to share your Inno script for creating installation programs? If so, I would appreciate a copy off-line.

TIA,

John Ruff - The Eternal Optimist

John Ruff - The Eternal Optimist :-)
 
Old August 18th, 2003, 05:50 PM
Authorized User
 
Join Date: Aug 2003
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to huskie
Default

My server won't let me copy the file onto my account because my current membership restricts me from uploading certain file types. Sorry. And what's ur email, cause I can send it to you as an attachment.

- MarkSeymour
 
Old August 18th, 2003, 06:46 PM
Registered User
 
Join Date: Jun 2003
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Could you email the file direct to [email protected]?

John Ruff - The Eternal Optimist :-)





Similar Threads
Thread Thread Starter Forum Replies Last Post
HowtoRun package from .asp from Package Store? Tom de Koning BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 0 June 21st, 2006 08:08 AM
don't run my package when i schedule package Isra2005 SQL Server DTS 1 May 17th, 2005 01:34 AM
package Dennis Apache Tomcat 1 May 18th, 2004 10:26 AM
package issues drew JSP Basics 0 June 4th, 2003 06:01 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.