Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
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 16th, 2005, 02:14 AM
Authorized User
Join Date: May 2005
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Installing a access database program in VBA

I have learned more from this forum than I did when I was in college!! With the help from this forum I locked up a program for sale in access. Now I need little more Help.

What I want to do is copy my access program to a CD for sale. When this CD is inserted into a computer I want it to open an install wizard program. Then proceed with installing it.

                     What I need to know:

A. Can this be done with VBA?

B. an example of how get the computers attention just by inserting the CD. Then running my VBA program to start the install wizard user interface.

C. How to put whatever that commercial programs put in your register to prevent you from deleting their program and just reinstalling it to gain more time. So that the computer can detect your program has been installed on this machine once before.

D. How to disable the ctrl + shift key

Thanks for your help.

Mike Drumm

A hopeful beginner.

Old August 16th, 2005, 07:14 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG

You said, "What I want to do is copy my access program to a CD for sale. When this CD is inserted into a computer I want it to open an install wizard program. Then proceed with installing it."

First, copying your Access database to a CD is fine, but the user needs to have a copy of Microsoft Access to run it. The Access Developer's Tool has a version of Microsoft Access called "Run-Time" that you can distribute freely with your database so users can use it without having a full version of Microsft Access on their computers. Otherwise, they're stuck because you cannot make an EXE file. The closest you can do is an MDE file.

Installation wizards like the kind you speak of are possible via a third party program. I don't know if you can do it via VBA within your database because the user would have to open the database itself to activate it. It's like putting the cart before the horse!

There are ways to disable the CTRL+SHIFT key. Check the archives here. I don't know it offhand.

Good luck!

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Old August 16th, 2005, 08:53 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

Whew, you are a beginner. How good is this app?

As to issue C., most cots create their own registry keys on installation, and then create a value in the registry for the expiration date. Your uninstall program should leave the registry value intact. This means that the first thing your installation program should do is check for this hidden registry value and if its there, not allow reinstallation if the demo period has passed.

These safeguards check a hidden value against the system date/time. The only way around them is to reset your system date/time to a time during the initial demo period.

As to issues A and B, what you need to do is create your installation file. That CAN be vbscript, not VBA. But what you will need to do is to put an Autorun.inf file on the cd. When you put a data CD into your cd rom drive, and the drive is set to atourun, the system looks for "autorun.inf" This file is a text file that tells the system which file to run first, like a boot.inf file. So it should look like this:

open=YourInstallFile.vbs -switches 'if any
icon=Optional.ico 'file on CD

So if you create this file:


Then this file:
MsgBox "Hello World!"

Burn these two files to a cd, and then insert it into your cd drive. You should get a message box saying "Hello World!"


Old August 16th, 2005, 10:08 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

I may have steered you wrong. In Windows XP SP2 I can't autoplay a .vbs file. I am looking into this.
Please also see www.advisor.com and the Access Advisor magazine for ads on installation products.

Old August 22nd, 2005, 02:48 AM
Friend of Wrox
Join Date: Jul 2005
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts

check this out: http://www.utteraccess.com/forums/sh...b=5&o=&fpart=1

"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.

Similar Threads
Thread Thread Starter Forum Replies Last Post
RS-232 and Access 2007 VBA database Gajun BOOK: Beginning Access 2007 VBA ISBN: 978-0-470-04684-5 1 June 2nd, 2010 11:08 AM
INSERT into Access Database from VBA for Excel zuerlein Excel VBA 0 June 3rd, 2007 01:51 AM
Send Keystrokes to DOS Program from Access VBA Cosmos75 Access VBA 6 May 15th, 2007 06:24 PM
Create/Add controls to Access Form: VBA program AccessBeginner Access VBA 1 October 13th, 2005 06:48 AM
Access VBA problem with Oracle database pankaj_daga Oracle 0 September 7th, 2004 08:47 AM

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