Hi Guys,

Is there any way to create an installation file (like a batch file) using VBA? (I don't have Office Developer by the way)

Assume all necessary files (.mdb or Winzip.exe)are in the CD, then once I run the file or code it should do the ff:
1) Create the required or defined folder.
2) Copy or unzip all necessary files (.mdb) on the above created folder.
3) Create a shortcut on the desktop.

Any help or idea is highly appreciated...


TIA,
George

Hi George,

I have not done this in VBA, but if you have access to InstallShield or Wise 
Installmaster, this would be a very easy thing to do (I'm actually a 
Software Configuration Engineer by trade). Do you have access to either of 
these software packages?


>From: "George Oro" <george@c...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] Installation Package
>Date: Mon, 23 Sep 2002 18:51:19 +0400
>
>
>Hi Guys,
>
>Is there any way to create an installation file (like a batch file) using 
>VBA? (I don't have Office Developer by the way)
>
>Assume all necessary files (.mdb or Winzip.exe)are in the CD, then once I 
>run the file or code it should do the ff:
>1) Create the required or defined folder.
>2) Copy or unzip all necessary files (.mdb) on the above created folder.
>3) Create a shortcut on the desktop.
>
>Any help or idea is highly appreciated...
>
>
>TIA,
>George
>
>
>
>




_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

Hi George!

There's been a bit of chat over the last month or two about doing this using
batch files.

I have a batch file that I use to install my front-end on users local hard
drives.

I can send this to you if you wish! It is not exactly what you want but with
a bit of work it could be!

Regards!
Chris Foote

> -----Original Message-----
> From: George Oro [mailto:george@c...]
> Sent: Monday, September 23, 2002 3:51 PM
> To: Access
> Subject: [access] Installation Package
> 
> 
> 
> Hi Guys,
> 
> Is there any way to create an installation file (like a batch 
> file) using VBA? (I don't have Office Developer by the way)
> 
> Assume all necessary files (.mdb or Winzip.exe)are in the CD, 
> then once I run the file or code it should do the ff:
> 1) Create the required or defined folder.
> 2) Copy or unzip all necessary files (.mdb) on the above 
> created folder.
> 3) Create a shortcut on the desktop.
> 
> Any help or idea is highly appreciated...
> 
> 
> TIA,
> George
> 
> 
> 
> 
> 

Look up Open Statement in Access VBA help.  The answer is you can create any
batch file you want.

|-----Original Message-----
|From: George Oro [mailto:george@c...]
|Sent: Monday, September 23, 2002 7:51 AM
|To: Access
|Subject: [access] Installation Package
|
|
|
|Hi Guys,
|
|Is there any way to create an installation file (like a batch
|file) using VBA? (I don't have Office Developer by the way)
|
|Assume all necessary files (.mdb or Winzip.exe)are in the CD, then
|once I run the file or code it should do the ff:
|1) Create the required or defined folder.
|2) Copy or unzip all necessary files (.mdb) on the above created folder.
|3) Create a shortcut on the desktop.
|
|Any help or idea is highly appreciated...
|
|
|TIA,
|George
|
|
|
|
|

Chris would you be so kind as to send a copy of the batch file to me as 
well? kennyalligood@h... Thanx in advance

Kenny

Chris I hope you don't mind to send me a copy of the batch file :D

Thanks,

Enzo

-----Original Message-----
From: Foote, Chris [mailto:Chris.Foote@u...]
Sent: Monday, September 23, 2002 11:37 PM
To: Access
Subject: [access] RE: Installation Package


Hi George!

There's been a bit of chat over the last month or two about doing this using
batch files.

I have a batch file that I use to install my front-end on users local hard
drives.

I can send this to you if you wish! It is not exactly what you want but with
a bit of work it could be!

Regards!
Chris Foote

> -----Original Message-----
> From: George Oro [mailto:george@c...]
> Sent: Monday, September 23, 2002 3:51 PM
> To: Access
> Subject: [access] Installation Package
> 
> 
> 
> Hi Guys,
> 
> Is there any way to create an installation file (like a batch 
> file) using VBA? (I don't have Office Developer by the way)
> 
> Assume all necessary files (.mdb or Winzip.exe)are in the CD, 
> then once I run the file or code it should do the ff:
> 1) Create the required or defined folder.
> 2) Copy or unzip all necessary files (.mdb) on the above 
> created folder.
> 3) Create a shortcut on the desktop.
> 
> Any help or idea is highly appreciated...
> 
> 
> TIA,
> George
> 
> 
> 
> 
> 

Please Chris...

Appreciated!!!
Cheers,
George


-----Original Message-----
From: Foote, Chris [mailto:Chris.Foote@u...]
Sent: Monday, September 23, 2002 7:37 PM
To: Access
Subject: [access] RE: Installation Package


Hi George!

There's been a bit of chat over the last month or two about doing this using
batch files.

I have a batch file that I use to install my front-end on users local hard
drives.

I can send this to you if you wish! It is not exactly what you want but with
a bit of work it could be!

Regards!
Chris Foote

> -----Original Message-----
> From: George Oro [mailto:george@c...]
> Sent: Monday, September 23, 2002 3:51 PM
> To: Access
> Subject: [access] Installation Package
> 
> 
> 
> Hi Guys,
> 
> Is there any way to create an installation file (like a batch 
> file) using VBA? (I don't have Office Developer by the way)
> 
> Assume all necessary files (.mdb or Winzip.exe)are in the CD, 
> then once I run the file or code it should do the ff:
> 1) Create the required or defined folder.
> 2) Copy or unzip all necessary files (.mdb) on the above 
> created folder.
> 3) Create a shortcut on the desktop.
> 
> Any help or idea is highly appreciated...
> 
> 
> TIA,
> George
> 
> 
> 
> 
> 

Hi there all!

I realise that I've not sent the Batch file that I promised a while ago.
Apologies, I've been away.

This is based upon a file sent to this list a while ago by Andrew Haslett -
thanks Andrew!
This is what I've ended up with:

************************
* @echo off
* if not exist "c:\Program Files\<foo>\bar-a06.mdb" goto getdb:
* goto startdb
* :getdb
* md "c:\Program Files\jamling" >nul
* del "c:\Program Files\jamling\Jamling*.mdb" >nul
* copy "\\ntsc0001\ObsComp\ChrisFoote\Jamling-a06.mdb" "c:\Program
Files\jamling" >nul
* :startdb
* start "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "c:\Program
Files\jamling\Jamling-a06.mdb"
* exit
************************

I've preceded each line with "* " so you can see wordwraps.

Working through the code line-by-line:

* if not exist "c:\Program Files\<foo>\bar-a06.mdb" goto getdb:

Looks to see if the user has the latest version of the db, if they don't
then the code loops to "getdb", if they do, then the code goes to "startdb
instead.

"getdb" first makes c:\Program Files\<foo> which is where my db is located
on users machines I guess the ">nul" at the end of the line makes it ignore
errors ie the directory already exists.
"del "c:\Program Files\<foo>\bar*.mdb" >nul" deletes any previous versions
of my db.

The next line copies the latest version on the db from the networked drive
to the users c drive. Again I guess that ">nul" ignores errors.

"startdb" opens up Access and loads the latest version of the db. According
to one of my co-workers "start" tells the system to run Access in a new
window.

I've got this batch file on a networked drive. One each user's desktop is a
shortcut icon linked to this batch file. When the icon is clicked the batch
file checks to se if the user has the latest version on their local hard
drive. If so the batch file runs tha access app an d terniates. If not, it
deletes the old version and copies the new from the network drive to the
users local hard drive. And runs the app as above.

I hope this is of interest and makes senseguys! Sorry for the delay!

Regards!
Spike

BTW - if you are wanting to copy shortcut icons to users desktops you can
use a command similar to the following:

copy g:\<foo>\*.lnk "%userprofile%\desktop" - this will work for NT4.

If machines are Win95 (or Win98 I think!) you will nedd to use this:

copy g:\<foo>\*.pif "%windir%\desktop"
copy g:\<foo>\*.lnk "%windir%\desktop"

I've not tried this yet so I cannot vouch for how well this works!

Opps!

Please ignore what I sent earlier! Andrew's reply makes much more sense!

Regards!
Spike


> -----Original Message-----
> From: Foote, Chris [mailto:Chris.Foote@u...]
> Sent: Friday, September 27, 2002 11:13 AM
> To: Access
> Subject: [access] RE: Installation Package
> 
> 
> 
> Hi there all!
> 
> I realise that I've not sent the Batch file that I promised a 
> while ago.
===========(Spike's rubbish snipped!)==========

> 
Hi George,

I see you have had some correspondence on the subject but I thought I 
would throw in my two cents.

Why not create an Access .mdb that installs your program. You could have 
the database start up and use an autoexec macro to start the installation. 
Then use the shell command to create all the folders. For example:  

Call Shell("C:\RUN.BAT", 1) in VB runs the bat file RUN.BAT which would 
create your directories. 

Of course you would have to do some batch programing which is a Dinosaur 
from the DOS days, but it can be done.

One Author used an Access .mdb to install his files for the examples in 
his book.

Good luck,

Dan


Hi Guys,

Is there any way to create an installation file (like a batch file) using 
VBA? (I don't have Office Developer by the way)

Assume all necessary files (.mdb or Winzip.exe)are in the CD, then once I 
run the file or code it should do the ff:
1) Create the required or defined folder.
2) Copy or unzip all necessary files (.mdb) on the above created folder.
3) Create a shortcut on the desktop.

Any help or idea is highly appreciated...


TIA,
George

Where's Andrew's reply?

Cheers,
George


-----Original Message-----
From: Foote, Chris [mailto:Chris.Foote@u...]
Sent: Friday, September 27, 2002 2:49 PM
To: Access
Subject: [access] RE: Installation Package


Opps!

Please ignore what I sent earlier! Andrew's reply makes much more sense!

Regards!
Spike


> -----Original Message-----
> From: Foote, Chris [mailto:Chris.Foote@u...]
> Sent: Friday, September 27, 2002 11:13 AM
> To: Access
> Subject: [access] RE: Installation Package
> 
> 
> 
> Hi there all!
> 
> I realise that I've not sent the Batch file that I promised a 
> while ago.
===========(Spike's rubbish snipped!)==========