Re: the warning below on using A2K and A97 (runtime or full) on the same

machine--the problem is that each time you start either product, it will

'reclaim' the Access file extensions (.mdb, .mde, .mda, et cetera).  So if

you open and close A97, double-clicking on an .mdb file in Explorer will

open it up in A97.  Likewise, if you open and close A2K, .mdb's will

thereafter want to open up in A2K.



This is for certain a PITA, but you can manage the problem by using

shortcuts that fully specify the location of the version of MSAccess.exe

that you want to use for a given .mdb.



Cheers,



-Roy



-----Original Message-----

From: Derrick Flores [mailto:Derrick_Flores@s...]

Sent: Wednesday, April 18, 2001 8:24 AM

To: Access

Subject: [access] Concealed





Subject:  Re: [access] Creating self executing Access Databases



You would need to use the MS Office 2000 Developer Edition.  Once you

install the software you would need to find a folder call "Runtime" that is

probably located on the 2nd CD.  You need to copy this folder to ...\Program

Files\Microsoft Office\ODETools\V9\Runtime.  This folder (Runtime) will not

be installed to your computer as part of the MS Office 2000 Developer Setup

program.  When you're about to package a database, open the database, go to

the VBA Projects Code module (ctrl + F11), Go to the Add-ins menu, Add-in

Manager, from there you will see a list of Add-ins.  Select the "Package and

Deployment Wizard" and click OK.  The Package and Deployment Wizard will

launch.  The reason that you have to copy the "Runtime" folder to your local

drive is that when you get ready to package a database you have the option

to include an Access 2000 Runtime for those computers that do not have

Access 2000 loaded on their machines. After you finished you packaging and

ready to install the software onto a computer, the software will check to

see if there is an Access 2000 Runtime software already loaded on the

machine.  If not, is will load it onto the computer and will restart the

computer before loading the Access database.  Once the software is finished

loading and restarting the machine, it will then load your database.  When

you install another database (even with runtime on it) it will by-pass the

Runtime installation and just load your database program.

*** WARNING : ONCE YOU INSTALL THE RUNTIME SOFTWARE ON THE MACHINE ALL

ACCESS 97 DATABASE ICON WILL CHANGE TO ACCESS 2000 ICON AND WHEN YOU OPEN

THE DATABASE FROM ACCESS 97, IT WILL GIVE THE OPTION TO CONVERT IT OR JUST

OPEN IT USING RUNTIME.  THIS WILL BE FOR ALL DATABASES ('97 & 2000).  TO

OVERCOME THIS YOU HAVE TO UNINSTALL THE MS RUNTIME SOFTWARE FROM THE

ADD-REMOVE SOFTWARE IN YOUR CONTROL PANEL.



Derrick A. Flores

Associate Systems Engineer

6" Line Engineering

Sony Electronic Inc.

Semiconductor San Antonio

1 Sony Place M/S 730

San Antonio, Texas 78245-2100

Telephone:  (xxx) xxx-xxxx

Fax:  (xxx) xxx-xxxx

Pager:  (xxx) xxx-xxxx

E-mail: derrick_flores@s...



>>> "Mark Collins" <mark.g.collins@s...> 04/18 12:38 PM >>>

All,



Does anyone know how to create self-installing Access programs.  I am 

currently working on a database which would look a lot more professional 

if I could install it via an installation program.  I know it can be done 

as my predecessor had distributed databases in this manner, which 

obviously makes the whole operation less painful.



Thanks in advance for any advice,

Mark.